Results 1 to 2 of 2

Thread: Transfer DTS package from SQL server 2000 to SQL server 2005

  1. #1
    Join Date
    Dec 2008
    Posts
    10

    Transfer DTS package from SQL server 2000 to SQL server 2005

    Hi,
    I have to migrate from sql server 2000 to sql server 2005 and have to transfer all database. This database contain some DTS packages and I have to transfer these DTS packages there.

    How can I do that one, I know SSIS, but I want to remain it as DTS packages as I donot want to chane its properties in 2005 server

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    Depending on number of DTS packages you have you can use different options.

    If number is low you can open each and save it in new server. You must install backward compatibility module separately in SQL 2005 to view these packages.

    For large number of packages, you can transfer data from sysdtspackages to corresponding table in SQL 2005.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •