I'm currently using System::SourceName to capture the failing task name in OnError. Unfortunately it is not available outside of the event handlers, and also does not capture the name of the container.
If I could get the current ssis app or package object, I could loop through the containers... I think like this:
List<DtsContainer> conContainers = new List<DtsContainer>();
conContainers = (IDTSSequence)package
But I'm not sure how to get the active package object of the package class. I don't want to create anything; I just want to read the .name off the current container object.
Edit: I'm just trying to do something like this:
string strContainerName = DtsContainer.Name; //where DtsContainer is the parent container
-------------------------------------------------------------------------------------------------
My SQL Server Blog