If you want a command-line utility, save the following code as a .vbs
file (e.g., savedts.vbs). Then you can run savedts.vbs <source server>
<package name> <dest server> and it will copy the package from the
source server to the dest server. Note that it uses windows
authentication so you would have to modify it to use a sql login. You
can then create batch files to copy multiple packages or schedule them
to run at a specific time or whatever.

Example usage:
cscript savedts.vbs devserver1 mypackage prodserver1

' savedts.vbs
Dim gsSourceServerName
Dim gsDestServerName
Dim gsPackageName
Dim goPackage

gsSourceServerName = WScript.Arguments( 0 )
gsPackageName = WScript.Arguments( 1 )
gsDestServerName = WScript.Arguments( 2 )

Set goPackage = CreateObject( "DTS.Package" )
goPackage.LoadFromSQLServer gsSourceServerName, , ,256 , , , ,
gsPackageName
goPackage.SaveToSqlServer gsDestServerName, , ,256
Set goPackage = Nothing


-----Original Message-----
From: Sanchez Anthony F
[mailto:mssqldba-ezmlmshield-x11471783.[Email address protected]
Sent: Monday, August 30, 2004 9:47 AM
To: LazyDBA Discussion
Subject: Moving DTS Packages...


Question,



Using the DTS transfer wizard, can I set msdb as the source and
destination databases and "select * from sysdtspackages" on the source?
My goal is to transfer DTS packages from one machine to another machine,
BOTH SQL Server 2000 boxes.



Are there better practices for this purpose? Can I accomplish this task
through a script?



Thanks!



Anthony.



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page