Post reply

Move DTS packages to SQL Server 2008 environment and continue to run them as DTS packages

  • June 17, 2010 at 3:07 pm

    #233923

    Hi,

    We have several DTS packages in SQL Server 2005 and we are upgrading to SQL Server 2008 and we are NOT ready to convert them as SSIS packages. So could you please list the order of steps to perform in order to move DTS packages to SQL Server 2008 environment and continue to run them as DTS packages?

    Please provide your inputs.

    Many Thanks

  • June 17, 2010 at 11:11 pm

    #1181913

    Hi,

    Your answer is available at the below website.

    http://msdn.microsoft.com/en-us/library/bb500440.aspx

    Thanks.

  • June 18, 2010 at 2:21 am

    #1181975

    From my experience, you are better off opening each DTS package and saving them to the new SQL 2008 server individually (rather than importing and exporting).

    We found that with exporting and importing, SQL often chose the wrong version of the DTS package and we ended up with an older version of the package on the new server- only an issue if you have multiple versions stored in each package.

    btw, we migrated from SQL 2000 to SQL2008...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply