I have a application on the test database (my local SQL server).
How to copy the DTS packages to the live SQL server.
When I import the datbase to the server, it does not copy the DTS packages,
only the tables, view and percudures. Any easy way to do it?


Many thanks
Lyn

Simplest method is inside the DTS Designer, select "Package" from the
toolbra, and then "Save As" then select the receiving server in the
dialog box that opens up.