Hi gurus,
When I try to use ActiveX script to load a DTS package from one server
(package.LoadFromSQKServer) and then save to another server
(package.SaveToSQLServer), I can succeed in doing this but the layout of the
DTS package on the destination server is totally trashed.
Anyone with excellent idea to solve the problem?

TIA
jeff

PS: I know I can use "save as" to another server ....

You can't do this

Moving in and out of ActiveX invalidates yor layout.


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"jeff_y" <nobsyxh (AT) tom (DOT) com> wrote

In message <Or8gJbOEFHA.3376 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, Allan Mitchell
<allan (AT) no-spam (DOT) sqldts.com> writes
copy method to transfer the packages between the system tables, so
bypassing the object model and it's little problem-

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