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
BedrockMission!

Learn More

View all

Sign in to view all badges

Error Handling

Avatar

Avatar
Validate 1
Level 2
poorvab56881543
Level 2

Likes

7 likes

Total Posts

9 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
poorvab56881543
Level 2

Likes

7 likes

Total Posts

9 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
poorvab56881543
Level 2

02-05-2018

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

Accepted Solutions (0)

Answers (0)