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?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply