Weird package behaviour on schedeling (network)

[Niels den Boer]

Hello,

We have constructed a package that export data to 2 tables
in a Microsoft Acces 97 database. This Access database has
a system database. For the connecting to de Access
database we use a path specified as \\network\blabla\...
etc. This is also the path to the system.mdw database.

When we run this package in Design mode as the
Administrator everything goes fine.

When we schedele the package (owner is sa) we get the
following errors:
---------------------------------------------------------
Executed as user: A12EM1DBAS01\SYSTEM. ...t: Copy Data
from dump_inzet_dag to `\\jerom\data\ureninzet\planninga12
\9900`.`dump_inzet_dag` Step DTSRun OnError: Copy Data
from dump_inzet_dag to `\\jerom\data\ureninzet\planninga12
\9900`.`dump_inzet_dag` Step, Error = -2147467259
(80004005) Error string: The Microsoft Jet database
engine cannot open the file ''. It is already opened
exclusively by another user, or you need permission to
view its data. Error source: Microsoft JET Database
Engine Help file: Help context: 5003051
Error Detail Records: Error: -2147467259 (80004005);
Provider Error: -67568648 (FBF8FBF8) Error string:
The Microsoft Jet database engine cannot open the
file ''. It is already opened exclusively by another
user, or you need permission to view its data. Error
source: Microsoft JET Database Engine Help
file: Help context: 5003051 DTSRun OnFinish:
Copy Data from dump_inzet_dag... Process Exit Code 1.
The step failed.
-----------------------------------------------------------

Does anyone have an explanation?? We have run out of ideas?

Thx,

Niels den Boer
The Netherlands

[Allan Mitchell]

Have you set the system database?
When you schedule a package it is the SQl Server Agent on the server running it
so drive mappings and the like go out of the window. Also check out Darren's
article about the system database.

INF: How to Run a DTS Package as a Scheduled Job [Q269074]

How can I dynamically set the Access System Database
http://www.sqldts.com/main.asp?nav=1,6,241,0

--

Allan Mitchell
http://www.sqldts.com