Post reply

Copy a DTS Package

  • 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

  • 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.

  • 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

  • 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

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

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