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

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@discussions.microsoft.com> schrieb im
Newsbeitrag news:03c201c4edb5$90d81400$a401280a@phx.gbl...
[quoted text, click to view]

In message <03c201c4edb5$90d81400$a401280a@phx.gbl>, anonymous poster
<anonymous@discussions.microsoft.com> writes
[quoted text, click to view]

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