SQL Server Performance Forum – Threads Archive

DTS packages

We have DTS packages running on SQL2000. There are plans of moving to SQL2005. Do we have to convert our old DTS package so that it will work with SQL2005? What is the best way to make it work on SQL 2005? Any help would be greatly appreciated.

Packages can be migrated successfully and completely because they contain only tasks and use only features that map to SQL Server 2005 Integration Services (SSIS) tasks and features. Packages contain SQL Server 2000 DTS tasks and features that cannot be migrated directly to SQL Server 2005 Integration Services (SSIS) tasks and features, but package functionality is preserved through the use of encapsulated SQL Server 2000 packages. http://msdn2.microsoft.com/en-us/library/ms143501.aspx http://msdn2.microsoft.com/en-us/library/ms345141.aspx You can also run the dts packages without migration after installing DTS add-ins… http://www.microsoft.com/downloads/…60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thanks Mohammed! <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />

If the business logic for those DTS packages are complicated or involves any stringent process then its better to rewrite in SSIS to take advantage of new features. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
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.

]]>