Moving DTS Packages from production to test

  • SQLGuy64

    Ten Centuries

    Points: 1051

    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

     

  • Jeff Gray

    SSChampion

    Points: 10637

    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

     

  • SQLGuy64

    Ten Centuries

    Points: 1051

    OK, thanx

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

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