Best Way to Read an Excel Spreadsheet Row By Row

Question

So we have to process an Excel spreadsheet row by row...performing lookups against SQL Server Tables for various touchpoints within an Excel Row.

What is the best way to do this?

Via a For Each Loop Container or via a Data Flow to process row by row of an Excel spreadsheet?

Thanks for your review and am hopeful for a reply.

Answer 1

Hi @Bobby P ,

You may use lookup-transformation.

The Lookup transformation performs lookups by joining data in input columns with columns in a reference dataset. You use the lookup to access additional information in a related table that is based on values in common columns.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Bobby P ,

You would need to use (1) Data Flow Task and (2) Lookup Transformation inside of it.