Hi:

I am not going to creating the install shield, but I need to find out
for the developer how to create a .dts package during an install
routine (actually take an existing package .dts file and create it on
the SQL Server the install is being run on). You would have to use DMO
for this, right? Does anything special need to be installed on SQL
Server? Any code samples for this?

Thanks,
Kayda

DMO has nothing to do with DTS. To move DTS packages around you have a
number of ways but a lot of people find this article useful

Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)


As for things you will need to have on the client box. This article
should see you right

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


Allan

"Kayda" <blairjee (AT) gmail (DOT) com> wrote