DTS error -2147467259
From: Sam (anonymous_at_discussions.microsoft.com)
Date: 04/07/04
- Next message: Kim: "Re: Dynamically determine which server DTS is saved to"
- Previous message: Maria: "How do I get month NAME from a date?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 7 Apr 2004 07:20:21 -0700
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.
- Next message: Kim: "Re: Dynamically determine which server DTS is saved to"
- Previous message: Maria: "How do I get month NAME from a date?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
