Running Data Transformation Services (DTS) Packages
SQL Server 2008 provides optional management, run-time, and design-time support for SQL Server 2000 Data Transformation Services (DTS) packages that were created by using the DTS tools and object model.
Data Transformation Services (DTS) is deprecated. For more information, see Data Transformation Services (DTS).
For more information about using DTS packages after installing SQL Server 2008, see the following topics:
For information about how to install support for DTS, see How to: Install Support for Data Transformation Services Packages. SQL Server 2008 does not install run-time support for DTS packages. You have to install this run-time support before you can run DTS packages.
For detailed information about how to use DTS with SQL Server 2008, see Support for SQL Server 2000 DTS in SQL Server 2008 R2.
For important information about how to secure DTS packages, see Securing DTS Packages Stored in SQL Server.
In SQL Server 2008, with Integration Services and the Backward Compatibility components installed, you can run DTS packages by any one of the following methods:
Use the Execute DTS 2000 Package task to run a DTS package from inside an Integration Services package. For more information, see Execute DTS 2000 Package Task.
Use the dtsrun utility (dtsrun.exe) to run a DTS package at the command prompt.
Use SQL Server Agent to run a DTS package by setting the job step to Operating system (CmdExec) and using the dtsrun utility to run the package.