I've been using SSIS for a while but am having my first foray into proper error handling. I've got a load of data flow tasks and I'm setting up an OnTaskFailed event for each one. The event is an Execute SQL Task component running a stored proc which I want to insert the name of the offending task into an error log table.
The problem is getting the name of the task that failed. If I select the System::TaskName variable, it sends the name of the Execute SQL Task component, rather than the name of the task that actually failed.
So how do I get the Execute SQL Task component to send the name of the Data Flow task to the stored proc, rather than its own name?