July 20, 2009 at 4:49 pm
In our packages we use a global error handler (Package level OnError Event). I have a situation where I will allow a data flow task to fail a few times before manually raising an error.
The data flow task is in a ForLoop container with a forced result of Success so the package does not fail, but each time the data flow fails it fires the global handler. Need to stop the global handler from firing.
July 20, 2009 at 5:33 pm
Add an OnError handler for the data flow task (or the FoorLoop container - depending on your needs) and set the system propagate variable for that task to False. This forces the task/loop not to bubble up the error to the package's global error handler.
July 20, 2009 at 7:50 pm
Thanks that's exactly what I was looking for.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy