Hello all

I have a small app that does some file exporting from an SQL server. On
this SQL server a DTS package is run to draw in data from a dBase
datasource. In the application I have written a routine that will run
the DTS package on the server and report success or failure, the
application runs fine on the server or on a workstation where SQL 2000
client tools are installed. I would like to install this application on
a workstation where SQL client tools are not installed. How do I go
about packaging the mssqldts.dll i believe so that the references /
components are available on the workstation? Does that make sense?
Please help

john

Hi John,

John Wildes wrote:
look on the SQL Server CD. There is a redist.txt file describing which files you are allowed to redistribute, which you need for
which SQL Server Component, and which components must be registered.
Also look here http://www.sqldts.com/default.aspx?225

HTH
Helge

Take a look at http://www.sqldev.net/download/dts/DotNETCookBook.pdf

If you create the file Microsoft.sqlServer.DTSPkg80.dll based on that
document, thats the only file you need to include in the .NET package.

Bart

On Wed, 18 May 2005 16:14:55 -0500, John Wildes <jwildes (AT) gmail (DOT) com>
wrote:

In message <5gjp8193c1snki52st8firh3ajuei37khg (AT) 4ax (DOT) com>, Bart
<?@?.?.invalid> writes

No, you will still need all of the other DTS DLLs listed in Redist.txt.
All that does is give you a RCW that allows you to call the DTS COM Dlls
from .Net, which has probably already been done by adding a reference in
the project. This is probably a better way, but you still need both.

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

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