We're working on a VB COM component that will dynamically build a DTS package using user inputs and configuration files. We have it working in a single-server test environment, but just realized that in production this component would be running on a machine that does not have a SQL Server installation on it. Now we're concerned about the Microsoft DTSPackage Object Library being available to make the necessary DTS calls.

So my questions are:
a.. Has anyone had to implement programatic DTS packages processing from a machine that does not have SQL Server installed?
b.. Does the SQL Client Tools install include the object libraries? (I haven't been able to find any articles that list in detail what the client tools install includes, and not sure we have a machine with just the Client Tools installed.
Thanks,
Moe.

In article <eepDzEBwDHA.3116 (AT) tk2msftngp13 (DOT) phx.gbl>, M.Oro
<oromm (AT) yahoo (DOT) com> writes
Simplest method is to install the client tools (Enterprise Manager is
the key component), or you can install the components manually-

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

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

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