The DTSErrorRecords collection allows an application to append error records to the OLE DB IErrorInfo interface of the current thread. This information can be provided by a Microsoft® ActiveX® script.
Handling DTS Events and Errors
IDTSDataPumpErrorSink