Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSIS: OnPostExecute OnError issue

Tags:

ssis

onerror

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

like image 223
Daniel Sh. Avatar asked Jun 28 '26 08:06

Daniel Sh.


1 Answers

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

like image 82
Diego Avatar answered Jun 30 '26 23:06

Diego



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!