Is there a way to copy/export a DTS job?

#1

Is there a way to copy/export a single DTS job from one server to another?
If so, how?

THanks,

SC

#2

http://www.sqldts.com/?204

--
Andrew J. Kelly SQL MVP

<me (AT) privacy (DOT) net> wrote

Quote:

Is there a way to copy/export a single DTS job from one server to another?
If so, how?

THanks,

SC

#3

Hi,

I have just posted a similar question minutes ago and
hopefully we can get answers.

Jonathan

Quote:

-----Original Message-----
Is there a way to copy/export a single DTS job from one
server to another?
If so, how?

THanks,

SC

.

#4

You can do it by opening the package and save as structured storage file
instead of sql server ..

Here's a tool that can dump lots of packages and load them again (but it
isn't required ... just makes it easier)

http://www.sqldts.com/default.aspx?242

Michael

<me (AT) privacy (DOT) net> skrev i en meddelelse
news:uM8tEmqPEHA.3012 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

Quote:

Is there a way to copy/export a single DTS job from one server to another?
If so, how?

THanks,

SC

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Is there a way to copy/export a DTS job?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Is there a way to copy/export a DTS job? - 05-20-2004 , 03:32 PM

Re: Is there a way to copy/export a DTS job? - 05-20-2004 , 03:46 PM

Is there a way to copy/export a DTS job? - 05-20-2004 , 04:45 PM

Re: Is there a way to copy/export a DTS job? - 05-21-2004 , 03:55 AM