Hello,

Currently I save a DTS as a storage file. I then run the storage file
with VBA code in the .adp(Access Data Project). This works if you run
the ADP on the Server but the users of the .adp will be opening it on
the network from their machines. When they do it says missing
custtask.dll and some other .dll these .dll are in the SQL server Binn
on the server so they are not on the users machines.
I could not register the .dlls on the user machines without SQL Server.

It would be great if I could solve this problem but I'm not sure
how.....

Another possiblity would be to save the DTS SQL Server msdb table and
run it from the server but I do not know how to run the DTS using VBA
code or a SQL statement...

Please help with any documentation or suggestions,

Chuck

The package will be executed from the computer saying "run". Therefore
you will need to have the dlls on the "run" computer to be able to do it
this way.

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


Allan



"meyvn77 (AT) yahoo (DOT) com" <meyvn77 (AT) yahoo (DOT) com> wrote

I tried to register the custtask.dll on the machine that would execute
the package but it would not register. Will it register without SQL
server on the machine or does it need to be registered in a certain
folder?

Technically it does not need to be registered in a given folder but
whatever structure you chhose should resemble the article on the site I
sent.

That said. It is safest to take a look at an existing SQL Server
installation, find out where all the files reside and build your
structure just like that.

Allan



"meyvn77 (AT) yahoo (DOT) com" <meyvn77 (AT) yahoo (DOT) com> wrote