Error Handling



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?



Accepted Solutions (0)

Answers (0)