Re: dts and access db
From: JFB (jfb_at_newSQL.com)
Date: 11/09/04
- Next message: JFB: "Re: Attachments with Send Mail Task"
- Previous message: Mark Allison: "Re: logging the volume of data loaded other the network?"
- In reply to: Sue Hoegemeier: "Re: dts and access db"
- Next in thread: Sue Hoegemeier: "Re: dts and access db"
- Reply: Sue Hoegemeier: "Re: dts and access db"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 9 Nov 2004 09:33:17 -0500
Tks for u reply...
1. The server have full control of the data folder.
2. Nothing in the article affects my problem.
3. The pkg doesn't fail manually, no errors.
4. Here is the error detail when it runs as a job schedule:
Executed as user: SQLSERVER\SYSTEM. ...cuting... DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1,
Error = -2147467259 (80004005) Error string: The Microsoft Jet
database engine cannot open the file '\\server\Data\Data.mdb'. 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 '\\server\Data\Data.mdb'.
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:
DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process
Exit Code 1. The step failed.
JFB
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:d910p053vuphhmhnvdlkajsjee2lavpb2s@4ax.com...
> It depends on what the specific permissions error is. If you
> are positive it's nothing in the article then it could be
> just the nature of some access issues. Does the service
> account for SQL Server have full control on the folder where
> the ldb file is created? Does it always fail? Is the Access
> database opened by another user or users when you get the
> errors?
> Posting the exact error message when you run it manually
> would help. If it's Access specific related to some of the
> above then you should hit similar error messages when run
> manually. It won't matter whether it's scheduled or not.
>
> -Sue
>
> On Mon, 8 Nov 2004 18:06:11 -0500, "JFB" <jfb@newSQL.com>
> wrote:
>
>>I'm using sa account with secure pwd... other dts are in the same way
>>without any problem.
>>I already read this article.
>>Anything else to think about ???
>>Tks
>>JFB
>>
>>"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
>>news:eygQdWcxEHA.412@TK2MSFTNGP14.phx.gbl...
>>> Under what account is the job scheduled?
>>>
>>> Have a look here
>>>
>>> http://support.microsoft.com/?kbid=269074
>>>
>>> --
>>>
>>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>>> www.SQLDTS.com - The site for all your DTS needs.
>>> www.Konesans.com
>>>
>>>
>>> "JFB" <jfb@newSQL.com> wrote in message
>>> news:eiTz0WbxEHA.3844@TK2MSFTNGP12.phx.gbl...
>>>> Hi,
>>>> I want to schedule a package to import access database to sql2000
>>>> server
>>>> (sp3).
>>>> The pkg fail with permissions error... what do I neet to have in mine
>>>> for
>>>> schedule pkg?
>>>> Do I need to install access in my sql2000 server?
>>>> The pkg is running ok manually.
>>>> Tks in advance
>>>> JFB
>>>>
>>>>
>>>>
>>>
>>>
>>
>
- Next message: JFB: "Re: Attachments with Send Mail Task"
- Previous message: Mark Allison: "Re: logging the volume of data loaded other the network?"
- In reply to: Sue Hoegemeier: "Re: dts and access db"
- Next in thread: Sue Hoegemeier: "Re: dts and access db"
- Reply: Sue Hoegemeier: "Re: dts and access db"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
