SQL Server Performance

DTS packages

Discussion in 'SQL Server 2005 Integration Services' started by v1rtu0s1ty, Apr 3, 2007.

  1. v1rtu0s1ty New Member

    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.
  2. MohammedU New Member

    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.
  3. v1rtu0s1ty New Member

    Thanks Mohammed! <img src='/community/emoticons/emotion-1.gif' alt=':)' />
  4. satya Moderator

    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.

Share This Page