Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Error Handling

Level 2
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?



0 Replies