Within SQL 2005 within the Event Handler tab I created a an Execute SQL Task with the following SQL statement; -
INSERT INTO dbo.CustomSSISLog (SourceName, SourceDescription, ErrorDescription,PackageName,ErrorCode,TaskName) VALUES (?,?,?,?,?,?)
In conjunction with using the Parameter Mapping tab to map parameters to system variables the above work's quite well. However the TaskName contains the name of the task which inserts the error record, I want it to contain the name of the Task (SSIS component) which
triggered the error.
Also I need the error record to contain the actual table, column and value in the column which triggered the error, any ideas? There does not seem to be readily available system variables to do this.
If you have found any of my posts helpful then please vote them as helpful. Kieran Wood MCTS BI, PGD SoftDev (Open), MBCS http://uk.linkedin.com/in/bileeds
View Complete Post