I have a data flow task, placed within a Foreach Loop Container, this is because i want it to dynamically load multiple excel files to the destination table. I am using SSIS to accomplish this task.
When I run the package I get 3 error messages. 1.[Excel Source [112]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. 2.[Excel Source [112]] Error: Opening a rowset for "'Athena Referrals 012017$'" failed. Check that the object exists in the database. 3.[SSIS.Pipeline] Error: "Excel Source" failed validation and returned validation status "VS_ISBROKEN".
And i have checked multiple times if the 'Athena Referrals 012017$' sheet is present, and it is there.
User contributions licensed under CC BY-SA 3.0