This Microsoft® Visual Basic® sample demonstrates how to execute programmatically a Data Transformation Services (DTS) package that has been saved in .dts format to a structured storage file. The package in the sample performs a copy operation from the pubs database to the pubs2 database.
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtstasks\DTSExecutePackage