Event Handler for On Error does not Execute

Question

Event Handler for On Error does not Execute

Welsh Corgi

SSC Guru

Points: 116520
More actions
June 28, 2012 at 7:08 am

#145386

I have defined an Event Handler for the On Error Event and it does not execute when there is an error.
I works just fine in another package.
Has anyone experienced this or have any idea why this would happen?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

I have configured error handling in the wrong scope on several occasions. It is very easy to do unintentionally. Check the scope of your error handler and make sure it is at the project level, or at the level of the object that is failing. Ideally you want all error handling at the project level, at least in my opinion.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Thanks, I have the Error handling at the Task Level within the Container.

That enables me to capture the task that fails as the source name.

I added a task at the project level and it is running but I would like to capture it at the task level.

I just don't understand why it is not executing the On Error Task?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

After moving the Task for the On Error Event to the Package Level it failed to execute.

If you select a task and then select the Event Handler Tab you click on a link and it allows you to define the actions that you want to perform when the error occurs.

There is an On Error Event for each task for a reason.

The package must be corrupt or something.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/