Post reply

SQL2005 and DTS Packages

  • October 30, 2006 at 3:01 am

    #67763

    I want to be able to use SQL Server 2000 developed DTS packages in a SQL Server 2005 installation. I have heard that there is a download from the MS site that provides a plug-in to allow SQL2000 DTS packages to run against SQLserver 2005 databases.

    Anyone out there done anything like this? What problems did you encounter, how did you get around them?

    Any contributions greafully received.

    Thanks.

    Duncan

    All the best,

    Duncan

  • October 30, 2006 at 10:51 am

    #668800

    I'm in the midst of developing a plan for migrating our DTS packages to SSIS packages, but I haven't done any yet.  I think you're referring to the DTS 2000 runtime and the Package Migration Wizard. 

    The Wizard is installed as part of the SSIS service and makes a best-effort attempt to migrate DTS packages to SSIS packages.  Complex packages that can't be migrated can be encapsulated in an Execute DTS 2000 Package task within an SSIS package.

    The DTS 2000 runtime is already present on the server if you already have SQL Server 2000 client tools installed.  If you don't, setup will offer the option to install it when you're installing SQL Server 2005.

    I found these articles to be helpful:

    http://qa.sqlservercentral.com/columnists/bknight/upgradingsqlserver2000dtspackagestossis.asp

    http://www.simple-talk.com/2005/11/18/dts-to-ssis-migration/

    I hope this helps a little.

    Greg

     

     

    Greg

  • October 31, 2006 at 9:08 am

    #668999

    Duncan,

    I just read this article this morning and it explains a lot about run-time support and design-time support for SQL Server 2000 DTS packages in SQL Server 2005.

    Greg

    Greg

  • October 31, 2006 at 11:21 am

    #669041

    You need to download Microsoft SQL Server 2000 DTS Designer Components from http://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en

    This will elable you to run and create DTS packages in SQL 2005.  Be warned though; it's a little buggy.

     

    There is also a backwards compatible module on the same page that you may need.

  • November 1, 2006 at 2:34 am

    #669155

    Simon & Greg, thanks very much for your input, it's much appreciated.

    I'm starting work on the migration next Monday. I'll post-up any interesting issues I encounter.

    All the best.

    Duncan

    All the best,

    Duncan

Viewing 5 posts - 1 through 4 (of 4 total)

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