Excel data source error when running SSIS package

Posted on 2006-05-25
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....
Question by:djoea
    LVL 30

    Expert Comment

    Do you have the file open in Excel at the time?

    Author Comment

    No. The file is closed and no one else is using it remotely either (not in a share).
    LVL 30

    Accepted Solution

    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??


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now