dbTalk Databases Forums  

Moving all DTS packages from server to server

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Moving all DTS packages from server to server in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
polinaskulski@aol.com
 
Posts: n/a

Default Moving all DTS packages from server to server - 05-17-2005 , 04:35 AM






Hi,
Is there any way of copying ALL DTS Packages from server to server
apart from direct copy of sysdtspackages table and saving them one by
one?
Thanks


Reply With Quote
  #2  
Old   
Simon Hayes
 
Posts: n/a

Default Re: Moving all DTS packages from server to server - 05-17-2005 , 04:57 AM






This tool can copy all packages or individual packages, and it also has
a command line version, so you can automate copying:

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

Simon


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.