Hi all,

How can I have my c# program execute a DTS package on a client PC that
doesn’t have SQL client tools installed?

I have a c# program that executes a DTS package on a SQL 2000 server. The
program works as expected when run on the development PC. When I install the
program on a client PC(Window's XP) I get the following error when the
application is run:

System.IO.FileLoadException: Retrieving the COM class factory for component
with CLSID {10020202-EB1C-11CF-AE6E-00AA004A34D5} failed due to the following
error: 8007045a. at SJHAPCheckPrint.formMain.RunDTS()

If I install SQL 2000 Client tools on the client PC then the application
works. The redist.txt file in the root directory on the SQL 2000 CD has:



INSTALLATION NOTES FOR DATA TRANSFORMATION SERVICES (DTS)

---------------------------------------------------------

The following files must be registered using the regsvr32.exe utility:

dtsffile.dll

dtspkg.dll

dtspump.dll

axscphst.dll



Example: regsvr32 80\Tools\Binn\dtsffile.dll



The sqlunirl.dll file should reside in the system folder (i.e.,
\winnt\system32 or \windows\system).



I included each of these dll’s in my install package. The sqlunirl.dll file
was placed in the System folder and the others in Program Files\Microsoft SQL
Server\80\Tools\Binn\dtsffile.dll. I flagged each of the 4 dll’s to be
registered by the install package but I get the message that the dll couldn’t
be registered.



Thanks in advance.

--
Langston

Look at this link:
http://www.sqldts.com/default.aspx?225

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk

"Langston" wrote:

This fixed my issue. Thanks.

--
Langston


"Charles Kangai" wrote: