DTS Package Executing from VB - Run time Error 429

[sqldevrequiretektips]

Hello Everyone

I have allready post this question on VB Forum but didn't get any response......

I have a VB program that calls a DTS package to import data from a text file into a database for reporting. The DTS package works wonderfully. The problem I'm running into though is creating an installer for my app with the right DTS files.

I'm using VB 6 and the DTS packages (2 different ones) live on SQL Server 2000. When I test my VB app on a PC that has the SQL client tools installed, the app works wonderfully and as planned.

When I test my VB app on a PC that doesn't have the SQL client tools installed, it gives me a runtime error 429, where Active X cannot create the object.

Here are the files I've included in my project:

axscphst.dll/.rll

dtsffile.dll/.rll

dtspkg.dll/.rll

dtspump.dll/.rll

sqlresld.dll

dtsrun.exe

dtsrun.rll

sqlwoa.dll

sqlwid.dll

I've tried placing them in the System32 directory and in the application directory, and the DTS part still fails.

Is this the right place to post this? Anyone ever run into this before and know how to get this to work, outside of installing the SQL client tools?

Thanks in advance!