Post reply

DTS to SSIS

  • October 23, 2013 at 11:02 am

    #278361

    Hi,

    I have over 200 DTS packages that I would like to migrate to SSIS on SQL 2008. DTS packages where build in SQL 2000 and modified in SQL 2005/2008. Does anybody have a good migration process?

    Thank you

    AK

  • October 23, 2013 at 2:41 pm

    #1661101

    This probably isn't the kind of advice you were looking for, but it's usually best to re-write your ETL in SSIS directly rather that attempt to migrate DTS to SSIS.

    There is an upgrade package option, but bear in mind that some tasks are not touched by the upgrade process, such as ActiveX scripts. Note that this is not much better when going from SSIS 2005 to SSIS 2008 +.

    In general, your process should be upgrade DTS, test test test, understand what it did, test test, re-write the bits that don't work any more, test, and deploy.

    However, you may not have to upgrade DTS at all if you can install the backward-compatability pack for SQL 2008. Check http://technet.microsoft.com/en-us/library/cc768544(v=sql.100).aspx for more details.

    Good luck ! 🙂

    [font="Courier New"]sqlmunkee[/font]
    [font="Courier New"]Bringing joy and happiness via SQL Server since 1998[/font]

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

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