[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel data source error when running SSIS package

Posted on 2006-05-25
5
Medium Priority
?
857 Views
Last Modified: 2008-01-09
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....
0
Comment
Question by:djoea
  • 2
3 Comments
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 16765324
Do you have the file open in Excel at the time?
0
 

Author Comment

by:djoea
ID: 16766050
No. The file is closed and no one else is using it remotely either (not in a share).
0
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 2000 total points
ID: 16781444
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question