Post reply

Moving DTS Packages from production to test

  • March 13, 2006 at 10:45 am

    #365560

    Would it be possible to write a vb application that:

    Reads all the SQL 2000 DTS pakages on a server saved at location SQL Server. 

    Save them as VB projects. 

    Loops through the saved  VB projects and reset global variables that relate to database connectivity.

    Reason:

    Want to automate moving packages from production to test.

    thanx, andy

     

  • March 14, 2006 at 8:58 am

    #626560

    Yes, you could.  I wouldn't do it that way.  For one thing, it is a lot of work.  The other thing I don't like about that is that when you save a package in VB, all of the pretty package formatting is not preserved. 

    Have a look a the BOL for "Dynamic Properties task".  You can set connection properties dynamically, usually in the first step of a package.

    jg

     

  • March 14, 2006 at 9:09 am

    #626566

    OK, thanx

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

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