Hi,

I have a security problem calling a DTS from a store Proc

If I launch the DTS manually no problem
If I call the same DTS from a store Proc I get this error

DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_11
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_11
DTSRun OnStart: Copy Data from JC65ANME JC CustomerManager Names to
JC65ANME Step
DTSRun OnError: Copy Data from JC65ANME JC CustomerManager Names to
JC65ANME Step, Error = -2147467259 (80004005)
Error string: [LINK]Error loading library
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file:
Help context: 0

Error Detail Records:

Error: -2147467259 (80004005); Provider Error: 117 (75)
Error string:
Error source:
Help file:
Help context: 0

DTSRun OnFinish: Copy Data from JC65ANME JC CustomerManager Names to
JC65ANME Step
DTSRun: Package execution complete.
NULL

In fact the Dts do run
Execute the first step
Fail at the second Step

The second step is a Task for copying data from an ODBC Data provider on
another server. We have to use a ODBC provider because we are importing Data
from an old version of accpac for dos.

We try to give the right Everyone with full Control on the Share folder
where the files are but it does not work.

Is there a solution of that type of problem?

Thanks in advance and have a nice day!