Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005

    Unanswered: Copying a DTS Package and Jobs

    Hi everybody,

    Just want to ask how can I copy a DTS Package? Something like "Save As"...saving a DTS Package to another package name in the same server, or copying a DTS package to another server.

    What I am doing right now, is I create the whole package again just to have another copy of it.

    Same question with a Job.

    Thank you so much.

  2. #2
    Join Date
    Oct 2006
    Why not try scripting it then just execute?

  3. #3
    Join Date
    Feb 2003
    for jobs u can right click on a job and use "generate sql script" to script it and execute it with QA.

    for DTS it is a bit tricky. u can save-as an open DTS package as "structured storage file" (location drop-down). copy that disk file to another machine. and then right click on Data-Transformation-Services to open that saved package. need to save it again in SQL server of that machine.

Posting Permissions

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