Post reply

Looking for help on stopping an OnError event

  • July 20, 2009 at 4:49 pm

    #212341

    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

    #1027362

    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

    #1027386

    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