• 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