April 22, 2016 at 7:29 am
I have an SSIS package that appears to be stopping after a ForEach Loop container. The container passes in an ID returned from a query. When no records are returned from the query, no ID is passed in and the procedure call within the container errors out. An OnError Event Handler was added, but now the package stops entirely when the Event Handler is hit. I would like to confirm if the way the OnError Event Handler was setup is causing the package to stop at that point. Can someone please direct me to where this option is configured? No objects were added to the Event Handler designer window. All we have are the Properties. Is one of the properties responsible for stopping or continuing the package? Thanks.
April 22, 2016 at 7:46 am
jonathanmarenus (4/22/2016)
I have an SSIS package that appears to be stopping after a ForEach Loop container. The container passes in an ID returned from a query. When no records are returned from the query, no ID is passed in and the procedure call within the container errors out. An OnError Event Handler was added, but now the package stops entirely when the Event Handler is hit. I would like to confirm if the way the OnError Event Handler was setup is causing the package to stop at that point. Can someone please direct me to where this option is configured? No objects were added to the Event Handler designer window. All we have are the Properties. Is one of the properties responsible for stopping or continuing the package? Thanks.
The error event happens first and the OnError event handler is called as a result. This is the behaviour I would expect. What are you expecting?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply