Copy a DTS Package

• maraclec

  Ten Centuries

  Points: 1175

  More actions

  October 2, 2003 at 6:15 am

  #106240

  Hello,

  I would like to make an exact copy a DTS package that I already only with a different name. Is this possible? If so, the next question is how?

  Thanks,

  Chuck

• slider

  SSC Enthusiast

  Points: 114

  More actions

  October 2, 2003 at 9:37 am

  #476812

  If it's just to be on the same server you can open the package and do a Package | Save As... just like you would in Word.

• LargoSQLTools

  Newbie

  Points: 1

  More actions

  October 3, 2003 at 7:48 am

  #476975

  What I often do is to right-click and select Generate Script, and then run the script after creating a new name.

  J.R.

  Largo SQL Tools

  http://www.largosqltools.com

• maraclec

  Ten Centuries

  Points: 1175

  More actions

  October 6, 2003 at 9:14 am

  #477206

  slider,

  Thanks for that. Worked perfectly, I didn't even think that it would be that easy.

  J.R.

  I can see your suggestion being perfect on different servers, but when I right clicked I didn't see a Generate script option. Could I have something not installed or set up properly.

  Thank you for your help,

  Chuck