DTSExecutePackage

DTS Programming

DTS Programming

DTSExecutePackage

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.

Default Location

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtstasks\DTSExecutePackage

Running the Sample
  1. Create the pubs2 database that is a copy of the pubs database on the local server.

  2. Open the DTSExecutePackage.vbp project.

  3. Run the application.

See Also

DTS Programming Samples