Excel data source error when running SSIS package

When I run a simple package to pull from an excel spreadsheet into a SQL 2005 database I get this error:

Error: 0xc0202009 at LoadDimension, connection manager "Excel Connection Manager": An OLE DB error has occured. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft Jet Database Engine" Hresult: 0x80004005 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."

The excel file I am reading from is local to my machine. There are no permissions set on the spreadsheet (Unrestricted access). I am also the administrator on the machine where the package is running, and I have full control to the file.

Any thoughts....
djoeaAsked:
Who is Participating?
 
nmcdermaidCommented:
Quickest way to find out the problem is to run filemon (sysinternals). Its a free program. It will tell you which user is trying to open it and you can work back from there.

If this was being run as a job, it was a remote SQL Server, and its service accounts are 'Local System', then this would definitely be because the SQL Agent doesn't have rights to open the file. However from your description that isn't the case here??

0
 
nmcdermaidCommented:
Do you have the file open in Excel at the time?
0
 
djoeaAuthor Commented:
No. The file is closed and no one else is using it remotely either (not in a share).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.