I have a DTS package that connects to an Oracle server and outputs a
csv file. I would like the user to be able to run the DTS package
without having an SQL server installed, so I want to exported it to vb
and compile it into an executable.

What is the best way to compile this code?

What is required to be installed on the user's system for the code to
run? The code references the DTS namespace, and I'm not sure if that
is something that is part of windows, or something added when I
installed the SQL client on my machine.

Thanks in advance.

shumaker (AT) cs (DOT) fsu.edu wrote:
If you have installed the tools, including Enterprise Manager then they
have DTS, if not yuou need to give them DTS in this way or by hand -

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

SQL Server the engine is not needed.

--
Darren
http://www.sqldts.com
http://www.sqlis.com