Classification: UNCLASSIFIED
Caveats: NONE

The reason this did not succeed was because I was using a network path to
access the file but I had not allowed sharing permissions to the system
account. Once I set that up it was successful :-)


-lance
Jeremy V. Lantz
SFC, SC, INARNG
IT Specialist (GS-2210-12)
Senior Microsoft DBA
USPFO for Indiana
Office: 317-247-3346
Mobile: 317-460-0759

A mistake does not become an error until one refuses to correct it.
-----Original Message-----
From: Lantz Jeremy V SFC NGIN
[mailto:mssqldba-ezmlmshield-x65791634.[Email address protected]
Sent: Thursday, November 29, 2007 7:30 PM
To: LazyDBA Discussion
Subject: RE: DTS Permissions to file denied? (UNCLASSIFIED)

Classification: UNCLASSIFIED
Caveats: NONE

I should have given more detail...

The DTS package is trying to read from a file that is place in a folder by a
user. This ran just fine when SQL ran under a domain account but, since I
set it up to use the local system account it is not working.

"System" has full control of the directory and like I said "everyone" has
read permissions. I can assure that the file is not open or in use by
anyone.

If I could even tell it to "execute as" that would be great but, no dice as
of current...

Thanks,

-lance
-----Original Message-----
From: Doug Ivison [address removed]
Sent: Thursday, November 29, 2007 3:40 PM
To: Lantz, Jeremy V SFC NGIN
Subject: RE: DTS Permissions to file denied? (UNCLASSIFIED)

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed any
attachments, and kept your email address secret **from this person, and any
viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text



1) This may sound silly, but... make sure the file is not already open.
(When the file is already open, you might get a "can't access" error...
especially when trying to rename/write to it.)

2) I've had strange results, when the DTS package is both creating the Excel
spreadsheet, *AND* then accessing it. I did not fix these errors... I merely
worked around them. The workaround: split it into two DTS packages -- one
that creates, and the other that accesses -- and then create a third,
"parent" DTS package that executes the first two (using the "execute package"
task).

HTH, and as always, let us know what you discover.



-----Original Message-----
From: Lantz Jeremy V SFC NGIN
[Email address protected]
Sent: Thursday, November 29, 2007 11:59 AM
To: LazyDBA Discussion
Subject: DTS Permissions to file denied? (UNCLASSIFIED)

Classification: UNCLASSIFIED
Caveats: NONE

I have a DTS package on my sql instance (SQL runs under local system
account). I keep getting an error that the microsoft jet database engine
can't open the file (excel source).

I have gone so far as setting the permissions to everyone with read write
execute but still it gives me the same error...

What am I doing wrong?

Thanks,

-lance
Classification: UNCLASSIFIED
Caveats: NONE



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html


Classification: UNCLASSIFIED
Caveats: NONE



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Classification: UNCLASSIFIED
Caveats: NONE


MS Sql Server LazyDBA home page