SQL Server 2000

This Microsoft® Visual Basic® sample illustrates some of the information that can be obtained from the Data Transformation Services (DTS) Application.GetPackageInfos method. It provides detailed information about the DTS packages on Microsoft® SQL Server™ 2000.

Default Location

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtssysteminfo\DTSPackageInfo

Running the Sample

This application uses Windows Authentication.

  1. Open the DTSSQLServerPackages.vbp.

  2. Run the application.

  3. Click DTS Package Info.

  4. Select the instance of SQL Server you wish to query.

See Also

DTS Programming Samples

© 2015 Microsoft