What is the best way to deploy a DTS Package using an installation tool
(WISE)? Our setup program installs MSDE, then uses a script to build the
database, but we are not sure how to handle the installation of the DTS
Package on a wide basis. We would like to fully automate the installation
if possible.

Thanks,

Joel

In article <ukwThzbjDHA.2312 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, news.microsoft.com
<jleachNO (AT) SPAMtroygroup (DOT) com> writes
If you are installing the package on the same machine as MSDE (and the
MSDE redist you are using includes the DTS DLLs) then the simplest
method would be to use file packages (Structured Storage File packages),
and just copy them to a known folder on the file system.


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

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

Hi Darren,

Thanks for the reply. I forgot to include the detail the they need to be
installed as a local package in MSDE. That is what the source code is
expecting. I'm thinking about writing a little VB utility (or VBScript)
that will take a Structured Storage File and install it as a local package,
unless there is an easier way?

Joel

"Darren Green" <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in
message news:0PHpa$AuLFh$Ew6x (AT) sqldts (DOT) com...

In article <e5ppEvcjDHA.744 (AT) tk2msftngp13 (DOT) phx.gbl>, news.microsoft.com
<jleachNO (AT) SPAMtroygroup (DOT) com> writes
That is probably the simplest method, load and then save them to SQL
server storage.

An alternative may be to export the relevant rows to an ADO file stream,
and then load them back in the similar way. This does have the advantage
that layout, annotations and package/version GUIDs are the same. You can
also do a similar export import process with DTS itself or BCP.

Just treat the packages as rows of data in a table (sysdtspackages).
After all that is what they are in this context.


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

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