I need to copy a rather complex DTS package from a Dev
server to the production server. The package was saved in
SQL Server. Is there a way to do this?

-Joseph

You can save the package as a file then load it onto the other server
and save it there.
If you are doing a lot of this you may find it easier to run all your
dts packages from files so that you just have to copy the file to a
directory to release it.

Nigel Rivett (SQL Server MVP)
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In article <37c601c34003$e894eee0$a401280a (AT) phx (DOT) gbl>, Joseph
<jwmills (AT) reliant (DOT) com> writes
Transferring DTS Packages
http://www.sqldts.com/default.aspx?6,105,204,0,1

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

Given that both servers have the same configuration, same
tables on the same databases (which validate all the
connections on the package in question), you can open the
package on the Dev server and do a save as to the PROD
server by selecting the Production server as the
destination server.