Deprecated Integration Services Features in SQL Server 2008 R2

This topic describes the deprecated Integration Services features that are still available in SQL Server 2008. These features are scheduled to be removed in a future release of SQL Server. Deprecated features should not be used in new applications.


For SQL Server 2008 R2, there have been no changes to the content that is listed in this topic.

Data Transformation Services (DTS)

Data Transformation Services (DTS) is deprecated. You should plan to remove dependencies on DTS in anticipation of future releases of SQL Server. Although SQL Server 2005 and SQL Server 2008 still include DTS functionality, the ability to migrate or run DTS packages might not be supported in the next release.

For more information about the deprecation of DTS, see Data Transformation Services (DTS).

For information about how to migrate DTS packages to the Integration Services package format, see Migrating Data Transformation Services Packages.