This Microsoft® Visual Basic® sample illustrates some of the information that can be obtained from the Data Transformation Services (DTS) Application object.
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtspackages\DTSApplicationObject