Exporting DTS Packages in SQL 2000

[jconway]

I have about 15 DTS packages on a server I'm about to migrate. I already backed up my database and restored it on the new server, but I don't know how to bring over all my DTS packages. Any help on this would be greatly appreciated.
Thanks,
Jen

 

[SQLDenis]

save them as structured storage files and copy them over

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[franklin1232]

Save them to .dts files. When you are in Local Packages just save as strutured storage file. It will have a .dts extension. Open them and save them locally on your new server.

I am sure there is a query that can pull them from a system table, but for 15 this is just as easy.

 

[RobertT687]

Be sure to change the server name in the packages after reimporting them.