Copying DTS tasks from one SQL Server to Another

#1

I have written several DTS tasks in EM that run nightly. I am moving my data
from one SQL Server 2000 installation to another SQL Server 2000
installation. Is it possible to copy my DTS tasks from EM on one machine to
EM on another machine?

--
Regards,

William

#2

you can use "Save As..." and save them on a different SQL Server by
specifying the new server name.
But if you have a lot of packages, use DTS Backup from SQLDTS.com
http://www.sqldts.com/?272

Simon Worth

William wrote:

Quote:

I have written several DTS tasks in EM that run nightly. I am moving my data
from one SQL Server 2000 installation to another SQL Server 2000
installation. Is it possible to copy my DTS tasks from EM on one machine to
EM on another machine?

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

Copying DTS tasks from one SQL Server to Another

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

Copying DTS tasks from one SQL Server to Another - 03-24-2005 , 01:01 PM

Re: Copying DTS tasks from one SQL Server to Another - 03-24-2005 , 02:15 PM