I have more that 200 DTS packages saved in "Local Packages" under SQL
Enterprise Manager. I know I can save them one by one to migrate to other
serevr.
Are there any easy way to migrate all 200 DTS ?

Thanks for help,

This article may help:

DTS -Transfer DTS Packages to SQL Server 2005 SSIS
http://searchsqlserver.techtarget.co...216481,00.html


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Mike Torry" <MikeTorry (AT) discussions (DOT) microsoft.com> wrote

For 2000 to 2005, here are some more links-

Upgrading DTS
(http://wiki.sqlis.com/default.aspx/S...radingDTS.html)


For 2000 to 2000 -

DTSBackup 2000
(http://www.sqldts.com/default.aspx?242)

Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)



--
Darren
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

"Arnie Rowland" <arnie (AT) 1568 (DOT) com> wrote