Post reply

Migrating DTS Packages

  • September 3, 2003 at 4:43 pm

    #59770

    Is there a way to migrate DTS packages from 7.0 to 2000 without doing them one at a time? I would like to move about 50 DTS packages from one Server to another.

    Thanks in advance for your time.

  • September 3, 2003 at 5:38 pm

    #472459

    The first, very easy step, is to move the packages themselves. I recommend a tool called DTSBackup 2000, it can be found at

    http://www.sqldts.com/default.aspx?272

    Also, have read of this short article,

    http://www.sqldts.com/default.aspx?204

    What comes next depends on on both the complexity of your packages and how they've been created.

    You might find that you will still need to re-visit each package and change server connection parameters, etc.. Although you can do this using VBScript to programmatically open the packages, modify the appropriate settings and then save them.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • September 4, 2003 at 12:56 am

    #472477

    quote:

    Is there a way to migrate DTS packages from 7.0 to 2000 without doing them one at a time? I would like to move about 50 DTS packages from one Server to another.

    Thanks in advance for your time.

    You might write a small VBScript for DTS Load from SQL Server and Save to structured file and 2nd script for Load from structured file and Save to SQL Server.

    I'm using this scripts with max pleasure 🙂 (without other tools) ... a small modification is in the Load script, where I change the target server name in DTS connections.


    ****************************************
    1: The question is ... "What is a MahnaMahna"?
    2: The question is ... "Who cares?"
    ****************************************

  • September 4, 2003 at 9:47 am

    #472600

    quote:

    You might write a small VBScript for DTS Load from SQL Server and Save to structured file and 2nd script for Load from structured file and Save to SQL Server.

    I'm using this scripts with max pleasure 🙂 (without other tools) ... a small modification is in the Load script, where I change the target server name in DTS connections.

    Could you share that code? I think it would prove extremely useful for myself (especially as my vb skills are somewhat lacking).

    Nic


    Shamless self promotion - read my blog http://sirsql.net

  • September 4, 2003 at 11:21 am

    #472630

    Phill's recommendation of

    http://www.sqldts.com/default.aspx?204

    is very easy , just coping a table.

    I've used that idea before. It works a treat

    Steven

  • September 12, 2003 at 8:36 am

    #473947

    Thanks for the suggestions. DTSBackup 2000 worked just fine.

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

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