sql server dts: I need install DTS package prpgammatically, without using Enterprise
Manager.

Is it possible to generate script for an existing DTS package and install it
on another server using this script?

If not, is there any utility that will allow me to do it? Just like dtsrun?
I know I can use dtsrun to execute a DTS package saved as a COM-structured
storage file.

Thanks a lot,
Lixin

Where are your packages stored?

You do not need a GUI to run, deploy, play with DTS packages. It makes it
easier sure but it is not compulsory. You need to use the DTS object
library which you get when you install the dlls

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

You can then use methods of the package object such as

LoadFromSQLServer
SaveToSQLServer.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
[quoted text, click to view]