The easiest way is to do a 'save as ' in a structured storage file and then
on the production server read this file into the DTS designer by right click
on the treeview item 'data transformation services' and choose 'open
package'. Then from the designer do again 'save as ' and store it on the
sql-server.

Regards,
Meinhard

"anonymous poster" <anonymous (AT) discussions (DOT) microsoft.com> schrieb im
Newsbeitrag news:03c201c4edb5$90d81400$a401280a (AT) phx (DOT) gbl...

I have a dts pagkage on a development server. How do I
move it to a production server when linked servers are
disallowed?

In message <03c201c4edb5$90d81400$a401280a (AT) phx (DOT) gbl>, anonymous poster
<anonymous (AT) discussions (DOT) microsoft.com> writes
Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)

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

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org