Writing error descriptions in the SSIS data stream (VS2008 BIDS)

Question

I am trying to use event handlers to log errors in my SSIS packages. Unfortunately, there is no way to add event handlers to individual tasks in a data flow task; Therefore, I added an event handler for the general data flow task at the control flow level.

When an error occurs in the data flow task, I would like this event handler to run once , recording the error and a possible description of the error.

I initially installed the OnError error handler trigger, however these are triggers several times (when the compound data stream task fails, when the general packet fails, etc.). I switched to the OnTaskFailed trigger, however it does not have the System :: ErrorDescription variable available for logging.

Am I missing something? Is it impossible to provide a single error message due to a data flow task failure? Is this something that is fixed in future versions?

This issue is in VS2008 BIDS

Answer 1

A brief error log using error handlers is not possible for data flow tasks in BIDS 2008.

The only parameters are direct registration of the data flow in the task itself (through SQL or script tasks) or recording of several error messages in the error handler of the control flow level.