Excel data source error when running SSIS package
Posted on 2006-05-25
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.