SSIS Excel Source OpenRowset From Variable Error - 0x80040E37

Question

When configuring an Excel Data Flow Component (Source) using the AccessMode of OpenRowset from Variable and setting the correct variable, I get the following error when trying to configure the shape/preview the data:

TITLE: Microsoft Visual Studio Exception from HRESULT: 0xC02020E8 Error at Merge Files [Excel Source [2]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37. Error at Merge Files [Excel Source [2]]: Opening a rowset for "[WORKSHEET]" failed. Check that the object exists in the database.

I have checked that variable name is correctly set to the name of a valid worksheet.

How do I fix this error?

PeterX · Accepted Answer · 2013-03-05 06:19:44Z

3

You need to append a dollar sign on the end of the worksheet variable, e.g. WORKSHEET$

answered Mar 5, 2013 at 6:19

PeterX

2,9313 gold badges36 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SSIS Excel Source OpenRowset From Variable Error - 0x80040E37

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related