Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!

Error Handling

Avatar

Level 2

I am trying to handle errors occurring at every stage of importing data from csv files to Staging table to the final stage of storing data into target table.

While doing so, I am trying to use the Update activity to store error counts at stage through $(vars.recCount).

Error handling through the Update activity seems to be an overhead and causing multiple issues. So as a workaround, I am planning to use SQL Code activity to store all the error record counts at each stage of data loading. I am trying to write usual sql code but getting error.

Can I get sample sql code with data binding?

Thanks,

Poorva

0 Replies