Hi,

As you know there are always customers who want fast delivery NO MATTER WHAT.

You can always query directly from the XLS source and by that bypass the ETL step.

Please find the attached code for OPEN ROW SET.

SELECT *

FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database={FileLocation}', [Sheet1$])

Enjoyee

Ronen