dbTalk Databases Forums  

Copying of DTS Packages from one server to another

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


Discuss Copying of DTS Packages from one server to another in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Yew Loon
 
Posts: n/a

Default Copying of DTS Packages from one server to another - 10-09-2003 , 02:27 AM






Hi

Another newbie question.

I have 2 unconnected SQL Server. How do I copy some
packages from one server to another ?

I tried Backup Database os the msdb database and Restore
it on the target, it overwrites everything there. The
previously existing packages created in the target server
is gone.

There has to be some better way of doing that.

Hope you can help. Thanks a lot.

Yew Loon

Reply With Quote
  #2  
Old   
John Bandettini
 
Posts: n/a

Default Copying of DTS Packages from one server to another - 10-09-2003 , 03:10 AM






Yew

Have a look at this link.

http://www.sqldts.com/default.aspx?6,105,204,0,1

Hope this helps

John

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.