Hello all!

I have a series of file-based DTS packages that I want to execute from our
web servers, and I have a couple of questions about the deployment of the
objects necessary to support these packages.

In my DTS packages, I have some ActiveX scripts that do some "package
manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need the
DTS COM objects to be installed and registered on the web servers?
Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
servers, so I'd probably need to install that (and any dependencies?) on the
Web servers.

I'm not really sure which files I need, or where to start looking. Are
there any licensing issues involved with having the DTS components on our
production web servers?

I'd be grateful for any assistance anyone can provide! :-)

John Peterson

Thanks Allan! I had *just* chanced upon that link when you replied. :-)

I notice that there's no mention of any licensing issues. Do you have any
suggestions regarding that?


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

This article is helpful

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

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"John Peterson" <j0hnp (AT) comcast (DOT) net> wrote

Licencing - yuck.

Have a look in redist.txt.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"John Peterson" <j0hnp (AT) comcast (DOT) net> wrote