Re: Export to Excel
From: Uwe Müller (commitsw.hd_at_t-online.de)
Date: 02/20/04
- Next message: Uwe Müller: "Re: DTS package looking for Universal Path."
- Previous message: Jason Callas: "Output to multiple text files"
- In reply to: AM: "Export to Excel"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 20 Feb 2004 18:20:06 +0100
hi unknown
maybe your dts-script has no permission to the file/directory
the access-level depends on the login of the sql-agent (system account or
special user)
uwe
"AM" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
news:76EB22C9-96F1-45F5-8D61-ABBECEA2C447@microsoft.com...
> Hi!
>
> maybe someone can help me with following. pleeeeeeeeeease.
> I have a desktop engine on my pc (XP). I create a DTS package on SQL
server through Enterprise Manager. Grabbing some data from SQL server and
exporting it to Excel. Everything works fine. However I need to run the
package from SQL server. So, when I try to do the same on the server,
connection to Excel fails. (Yeah, I am trying to open local file located on
the server, folder has permissions to everyone.) Trace gives this:
>
> Step Error Source: Microsoft JET Database Engine
> Step Error Description: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.
> Step Error code: 80004005
> Step Error Help File:
> Step Error Help Context ID:5003051
>
> I looked up for help etc, but found only advises as to close file if it's
opened etc.
>
> Someone please help.
>
> Thanks
>
>
- Next message: Uwe Müller: "Re: DTS package looking for Universal Path."
- Previous message: Jason Callas: "Output to multiple text files"
- In reply to: AM: "Export to Excel"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
