Hi,

I have an excel workbook that uses DTS via VBA Script and Referencing.
It executes an external process and then does some datapumping from a text
file to an access table and thats about it

The code runs fine on a machine with SQL Server 2000 installed (happens to
be Win 2000 Pro SP 2)

The code does not work on other client machines who don't have sql server.
No networking, all local files, all local access dbs (XP Pro)

I'm sure what dts actions I'm taking dictate what files I'll need, but I can
clearly see that the Package object can't be created at the outset.

I know the machine is missing the dts*.dll files, but I'm having trouble
a) regestering any dts*.dll file
b) knowing any and all files necessary

I have these three files
dtsffile.dll
dtspkg.dll
dtspump.dll

in folder c:\ocx

I try this:
regsvr32 c:\ocx\dtspkg.dll

This fails, it says
LoadLibrary("c:\ocx\dtspkg.dll") faled - The specified module could not be
found.
Same with the other two files

I don't mind registering any and all possible dts*.dll files on the client
machine, ...
any suggestions?

Does SQL Server have to be installed on the client machine? No way...right???

Any thoughts / suggestions...

thanks (in advance)
bs

Yes DTS must be installed on the PC doing the running of the DTS stuff

Have a look here


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

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"whaaaaa" <whaaaaa (AT) discussions (DOT) microsoft.com> wrote