I am using SSIS (SQL Server 2008) and trying to capture errors during control flow (Execute SQL task fails, etc). In the OnError event, I have trapped the error and gotten the error message from the system variable System::ErrorDescription.
I also have retrieved System::SourceParentGUID. I would like to use it to get the name of the parent container of the failed component. I haven't been able to find a way to translate the ID into a Name. I have found GetObjectById
but that seems limited to data flows. Thanks in advance.
View Complete Post