question

User1017BS avatar image
User1017BS asked

OnError event executing multiple times for one error

I have a ssis package that includes a foreach loop. The foreach loop cycles through the instances that are provided from a specific table. Once the loop hits an instance that cannot be contacted then the Onerror event should populate a results table once. For some reason the Onerror event is populating the table multiple times for this instance instead of just once. Can someone help me with this? I tried changing properties of DelayValidation and that did not help
ssissql servererror-handlingforeach-loop
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Can you debug it with a watch to see where the multiple entries are coming from?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.