Hi All,

We have a 3rd application that writes data to an Access database every hour.
I wrote a DTS package to import this data just after the data is written.
The package works fine when it's run in standalone mode (ie: executed
manually), but when I schedule the package, I get the following error:

Executed as user: SPSHR\SYSTEM.
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
Error string: Could not use ''; file already in use.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003045
Error Detail Records: Error: -2147467259 (80004005);
Provider Error: -67044352 (FC00FC00)
Error string: Could not use ''; file already in use.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003045
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete. Process Exit Code 1. The step failed.

Is there a way to force the DTS package to ignore the open status of the
database in order to read the data?

Thanks,

Brian.

Hello Brian,

This could well be because you do not have permissions when running as a
job. Not only will your Agent/Proxy account need perms to the DB but it
may also need perms onto the location of the ldb lock file.

Have a read of this

http://support.microsoft.com/?kbid=269074


Allan