Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    212

    Unanswered: Promoting DTS pacakages

    Environment: SQL Server 2000

    I have made a few DTS packages (in testing environment). Now I have to promote them to production environment. Whats the best way to do this? One of the ways I can think of is save the DTS packages in visual basic format and go through the VB code and check for any dependent variables etc. But once a DTS packages is saved as VB code it cant be saved back as a package. So how would you use the DTS package (in VB code) on SQL Server 2000.

  2. #2
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    Open the package in Design.

    Click Package, Save As...

    Select the server you would like to save the package to.

    Open it on the new server and check for dependencies.

    That's all there is to it.
    -bpd

  3. #3
    Join Date
    Sep 2003
    Location
    Germany
    Posts
    63

    A little helper for DTS Packages!

    Hi!

    For transferring a DTS-Package from one Server to another or for Backup purposes I use a little free tool called "DTSBackup 2000". You can find the description and the download link on the following page (http://www.sqldts.com/?242).

    Hope that makes it easier!
    Greetings,
    Carsten

  4. #4
    Join Date
    Sep 2003
    Posts
    212

    Re: A little helper for DTS Packages!

    Originally posted by CarstenK
    Hi!

    For transferring a DTS-Package from one Server to another or for Backup purposes I use a little free tool called "DTSBackup 2000". You can find the description and the download link on the following page (http://www.sqldts.com/?242).

    Hope that makes it easier!
    Greetings,
    Carsten
    Thanks, the software helped me out.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •