Results 1 to 4 of 4

Thread: dts package

  1. #1
    Join Date
    Jan 2003
    Posts
    11

    Unanswered: dts package

    I have about 30 dts packages created for different databases . I am rebuilding this server. How do I move the dts packages, I need to back them up into another server. And then restore and re-install them when the server is rebuilt. How do I back up and restore dts packages.
    Pls help

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: dts package

    Originally posted by dokeyemi
    I have about 30 dts packages created for different databases . I am rebuilding this server. How do I move the dts packages, I need to back them up into another server. And then restore and re-install them when the server is rebuilt. How do I back up and restore dts packages.
    Pls help
    You could save it as files
    or you can also backup all your databases included master and msdb and restore on your new server
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Jan 2003
    Location
    KL, Malaysia
    Posts
    38

    Unhappy Re: dts package

    Originally posted by omiossec
    You could save it as files
    or you can also backup all your databases included master and msdb and restore on your new server

    You mean save the files one by one individually? How about deploying them? Say I have 100 ++ DTS packages?
    Save the dugongs!

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245

    Re: dts package

    Check out www.sqldts.com. Look in their downloads section for something called DTSBackup2000. I have used it in a development environment with a tremendous amount of success. I have not yet had the courage to try it in production, but I'm getting pretty close.

    Regards,

    Hugh Scott

    Originally posted by dokeyemi
    I have about 30 dts packages created for different databases . I am rebuilding this server. How do I move the dts packages, I need to back them up into another server. And then restore and re-install them when the server is rebuilt. How do I back up and restore dts packages.
    Pls help

Posting Permissions

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