Post reply

Migrate SQL 7 DTS to SQL 2005 SSIS

  • May 15, 2008 at 9:51 am

    #182441

    Hello All

    Is anyone here familiar with migrating SQL 7 DTS packages to SQL 2005 SSIS.

    I have managed to migrate the databases although they are still not raised to the the SQL 2005 functional level.

    Is it possible to migrate the DTS straight to 2005 or is it necessary to migrate to 2000 first and then onto SQL 2005?

    Any help would be appreciated.

    Thanks 🙂

  • May 15, 2008 at 5:08 pm

    #816209

    Hi Darran, I am actually doing exactly what you are trying to do. The only thing you need is to have the dts structured file and then you can "migrate" it from a vs integration service project. Of course you will be using the migration wizard, yeah I know it says migrate 2000 dts but with the ones I had to migrate it worked just fine.

    But I guess you will have to check which SP your SQL Server 7.0 is using. I read that in order to be able to get your dts file managed as dts files from 2k, your sql 7.0 server needed to be SP 4. If not you will have to put them into a local sql 2k server and then you can use the migration wizard.

    I know this isn't the news you were expecting to hear but since Microsoft doesn't give any kind of support to sql server 7.0, your destiny is to have fun migrating your dts :hehe:

  • May 16, 2008 at 2:43 am

    #816309

    Hi

    Thanks for your response, I'll check out your ideas!

    Darran

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

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