• Hi,

    I am new to SSIS and followed the steps in this article as it is to create the error handler. If I execute the error handler SQL task manually it works fine and inserts into the DB but when the SSIS job fails it doesn't invoke the Error Handler at all. I have checked the DisableEventHandler property and it is set to False.

    I have also tried to use some help from the ticket

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e7fbe7e8-331f-49d5-88d3-715174688879 but that didn't help either.

    Can someone please guide me in the right direction. I am trying to resolve it for 2 days now.

    Thanks!