I am using SSIS to export an Excel 2007 file to a SQL table. When I execute my package locally it works; however, on the server I get the following error:
Data Flow Task:Error: Excel Source failed the pre-execute phase and returned error code 0xC02020E8.
Data Flow Task:Error: Opening a rowset for "Sheet$" failed. Check that the object exists in the database.
Data Flow Task:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
I have tried the following, with no success:
- changing the sheet name to just A
- Installing the Ace 12.0 driver
- Converted my Excel file to a flat file (that takes a long time, so the app times out)