I created a package, which contains, create a temp table
run query to get the data then load it to excel.
It works great if I run the package manually.
It fails when I schedule it with the following error
(I even set up the proxy account for the agent and still
fails)
Any help gratefully appreciated
Executed as user: John_Doe ...Create Table Results Step
DTSRun OnError:
Create Table Results Step, Error = -2147467259
(80004005)
Error string: The Microsoft Jet database engine cannot
open the file
'\\Zeus\HD_Reports\Referrals.XLS'.
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: -534709256 (E020FBF8)
Error string:
The Microsoft Jet database engine cannot open the
file '\\Zeus\HD_Reports\Referrals.XLS'.
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: Create Table Results Step
DTSRun OnStart: Copy Data from Results to Results Step
DTSRun O... Process Exit Code 2. The step failed.