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
[mailto:mssqldba-ezmlmshield-x77641894.[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


MS Sql Server LazyDBA home page