Geek Answers Handbook

OnTaskFailed event handler in SSIS

If I use the OnError event handler in my SSIS package, there are System :: ErrorCode and System :: ErrorDescription variables from which I can get error information if nothing fails at runtime.

But I can not find the same thing for the OnTaskFailed event handler , that is, how to get ErrorCode and ErrorDescription from the OnTaskFailed event handler when any things do not work at run time if we want to implement the OnTaskFailed event handler for our package?

+4
source share
2 answers

This may be useful, this is a list of all system variables and when they are available.

http://msdn.microsoft.com/en-us/library/ms141788.aspx

+1
source

In the task that you put on the error event handler, you can select the parameters that are available only in the error handler, for example, the system: Errordescription or system: Sourcename (which provided the task with which it failed). We use them as input variables for the stored process, which inserts into the error table (and sends an email to the failed process), which stores information other than the logging table. We also use the logging table to record our steps and in conjunction with the error, so that general error information goes there.

-one
source

More articles:


All Articles