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.


MS Sql Server LazyDBA home page