In my SSIS package, I'm trying to drop and recreate the excel worksheet before it gets populated by the next task.
I know the Excel connection is valid because the package inserts rows to the worksheet for that same Excel Connection.
Drop table Sheet1
CREATE TABLE SHEET1
But this SQL Task fails with this error:
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft Access Database Engine" Hresult: 0x80004005 Description: "'T:\Reports\ProductionReport1\ProductionReport1.xlsx' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.".
The Excel sheet is not open. What could be causing this?