CODEWITHSUNDEEP
ssisonerror
Daniel Sh.
Daniel Sh.

Reputation: 2074

SSIS: OnPostExecute OnError issue

I have a SSIS package where I set the OnError and OnPostExecute event handlers. The Package is a simple loop container and the handler OnPostExecute is working fine.

But the OnError is not actually working. Ive added some wrong-code to the task inside the Loop, just for the sake of testing the OnError handler and it's not activating. The OnPostExecute handler does work after very process inside the Loop.

On the other hand, Ive tried executing the OnError task by its own and it did work. So, it's not being activated when an error happens.

Some information. I have set the Propagate system variable to FALSE for every task inside the loop since I dont want the package to stop. (maybe this has something to do with it) The OnError handler is at package level.

Any idea about OnError not being executed when the process finds an error? Thanks

Upvotes: 3

Views: 3128

Answers (1)

Diego
Diego

Reputation: 36146

Check the "DisableEventHandlers" property. Make sure it is set to false on any of the tasks that it is not firing.

Upvotes: 1

Related Questions