sql server dts: If the source server can see the target server, then you could simply do a
'Save As', on the package (on source server) and select the target SQL
Server from the dialog box.

Alternatively, you could save a DTS package as a structured storage file
(.dts), and load that file on the target SQL Server.

Check out sqldts.com for more information.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


[quoted text, click to view]
How can I move a package from one server to another?