SQL Server Setup Help | |
Data Transformation Services (DTS) | |
Backward Compatibility > SQL Server Backward Compatibility > Support for Previous Versions of SQL Server > |
Data Transformation Services (DTS) has been replaced by SQL Server Integration Services.
SQL Server 2008 does not install DTS support. For more information, see Support for Data Transformation Services (DTS) in SQL Server 2008.
Data Transformation Services Is Deprecated
Data Transformation Services (DTS) is deprecated. You should plan to remove dependencies on DTS in anticipation of future releases of SQL Server. DTS itself will continue to be supported in SQL Server 2000, SQL Server 2005, and SQL Server 2008 as part of our ongoing commitment to provide support for those versions of SQL Server. However, the ability to migrate or run DTS packages might not be supported in the next release.
The DTS functionality that will be deprecated includes the DTS runtime, the DTS API, the Package Migration Wizard for migrating DTS packages to the next version of Integration Services, support for DTS package maintenance in SQL Server Management Studio, and the Execute DTS 2000 Package task.
For information on how to migrate DTS packages to the Integration Services package format, see Migrating Data Transformation Services Packages.