"whaaaaa" <whaaaaa@discussions.microsoft.com> wrote in message
news:80EFF021-B081-4CE8-B462-A214256B2DDF@microsoft.com...
> 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