The SSIS Package is loading Excel 2007 file using the MS Access OLEDB driver.
ERROR MESSAGE
Opening a rowset for "Sheet1$" failed. Check that the object exists in the database.
EX_SRC - Excel Generic file source using OLE connector failed validation and returned validation status "VS_ISBROKEN".
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
There were errors during task validation.
Error description
The Excel spreadsheet loads fine on the desktop in SSIS. It has been deployed to run through the SSIS catalog on the server using Active Batch as the scheduler. On the Test environment this also works ok. The error only occurs when running the package from the Production server.
Trouble shooting
The VS_ISBROKEN message normally indicates a metadata issue i.e. a column type has changed or a column is missing etc. To correct this you'd open up the the Data Flow task in SSIS reading from the affected spreadsheet and correct the issue or refresh the metadata. However when I do this in SSIS there are no errors reported, so nothing to fix or refresh.
Ensured that my desktop, the Test server & Production have the same driver version, same regional settings.
Thought the date column might be treated differently on the Production server which is causing the metadata "VS_ISBROKEN" error. As above checked that the regional settings on the Production server is the same as my desktop and get no errors locally.
Can't get SSIS installed on the Production to test it locally on the server.
I have a similar package loading an Excel 2007 format successfully, which rules out an issue with the driver not working correctly.
64bit is set to true as this is not using the Excel connection.
Any suggestions to further troubleshoot the issue?