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. :)Why not try scripting it then just execute?|||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.

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.Hey,

If you are using Enterprise manager, double click the package( or right click on the package, there will be a "Design package" option), it will open DTS Package designer, there you will find a menu under the main menu, click on Package and there will be a Save as... command there|||Hi Galexyus,

Thanks for taking the time to answer my query.
I found the "Save As" command already. What am I doing?
It's just in front of me, right before my very eyes. =)

Many thanks to you.
God Bless.