Just use DTSBackup 2000 from www.sqldts.com

It includes command-line functionality.

Also as an added bonus, if you're transferring from SQL Server to SQL
server, it has a direct transfer option that maintains text annotations
and the layout.





Thanks
Phillip Carter
Ph: +61 3 9235 1691


-----Original Message-----
From: RRazzano
[mailto:mssqldba-ezmlmshield-x8861115.[Email address protected]
Sent: Tuesday, 31 August 2004 3:08 AM
To: LazyDBA Discussion
Subject: RE: Moving DTS Packages...

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]



---------------------------------------------------------------------
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]


IMPORTANT DISCLAIMER - THIS MAY AFFECT YOUR LEGAL RIGHTS:

Because this document has been prepared without consideration of any
specific clients investment objectives, financial situation or needs,
a Bell Potter Securities Limited investment adviser should be
consulted before any investment decision is made.

While this document is based on the information from sources which
are considered reliable, Bell Potter Securities Limited, its directors,
employees and consultants do not represent, warrant or guarantee,
expressly or impliedly, that the information contained in this document
is complete or accurate.

Nor does Bell Potter Securities Limited accept any responsibility to
inform you of any matter that subsequently comes to its notice, which
may affect any of the information contained in this document.

This document is a private communication to clients and is not intended
for public circulation or for the use of any third party, without the
prior approval of Bell Potter Securities.


Disclosure of Interest: Bell Potter Securities Limited receives commission
from dealing in securities and its authorised representatives, or introducers
of business, may directly share in this commission. Bell Potter Securities
and its associates may hold shares in the companies recommended.

Bell Potter Securities Limited ABN 25 006 390 772 AFS Licence No. 243480

MS Sql Server LazyDBA home page