DTS For Sql 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS For Sql 2005

Hi , Not able to find DTS on Sql Server 2005 ? Anything else need to configured ? Thanks ,
– DTS is now SQL Server Integration Service
– you develop the packages using BI-Dev-Studio (= Visual Studio 2005 with SQLServer addins for SSIS, SSAS and SSRS)

If you want to use old dts packages you have to install dts addins… Feature Pack for Microsoft SQL Server 2005 – February 2007 Microsoft SQL Server 2000 DTS Designer Components
The Microsoft SQL Server 2000 Data Transformation Services (DTS) package designer is a design tool used by developers and administrators of SQL Server 2005 servers to edit and maintain existing DTS packages until they can be upgraded or recreated in the SQL Server 2005 Integration Services package format. After installing this download, SQL Server 2005 users can continue to edit and maintain existing DTS packages from the Object Explorer in SQL Server 2005 Management Studio and from the Execute DTS 2000 Package Task Editor in Business Intelligence Development Studio, without needing to reinstall the SQL Server 2000 tools. The DTS package designer in this download was formerly accessed from the Data Transformation Services node in SQL Server 2000 Enterprise Manager. http://www.microsoft.com/downloads/…94-8453-4998-8226-fa42ec403d17&displaylang=en
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

Checkhttp://www.sqlservercentral.com/columnists/vkumar/introductiontodtsinsqlserver2005.asp &http://www.databasejournal.com/features/mssql/article.php/3503996 on the subject. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.