DTS package to SQL 2012 SSIS

  • What is the best way to migrate SQL 2000/2005/2008 DTS packages to SQL 2012 SSIS. Is there an migration wizard in SQL 2012?

    Balasach

  • The best way? Well that really depends on how complicated the pkg is and what it does.

    However, I'll say that for anything other than the simplest pkgs I'd use the PragmaticWorks tool.

    It's quite excellent.

    I'll say though if you're not going to use the PW tool, just re-write them under the target platform.

    But no, there isn't a native DTS pkg converter.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

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

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