Support for DTS in SQL Server 2008

As we all know that SQL Server 2000 Data Transformation Services is already deprecated but SQL Server 2008 still supports DTS (Limited Functionality). SQL Server 2008 provides optional 32 bit management, run-time, and design-time support for packages that were created by using the DTS tools and object model.

Note:

  1. Please note that not all the functionality of DTS is not supported in SQL Server 2008.
  2. To get the DTS support in SQL Server 2008 you might have to manually install additional, optional components that are not available during setup.

For more information on which are the functionalities of DTS is supported in SQL Server 2008, please visit the below link

http://msdn.microsoft.com/en-us/library/bb500440(v=SQL.105).aspx

Happy Learning !!!