Importing data in ssis from source file(excel) to OLE DB destination. I am getting multiple errors and I cant figure out what the reason is

-1

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.

ssis
integration
ssis-2012
foreach-loop-container
asked on Stack Overflow Jul 30, 2018 by user3537234

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0