SSIS: ForEach Loop Container: Looping through Excel sheets with Uniforn columns but different sheet names

Question

If all data and columns are uniform in Excel but each worksheet has different names, will this disrupt my ForEach Loop Container?

Vikramsinh Shinde · Accepted Answer · 2014-06-25 22:18:57Z

1

If you create a variable of string type and assign the sheetname value to it dynamically then it won't affect your Foreach Container.

Please make sure that the variable name ends with "$".

So put some logic to retrieve sheetname first and then assign it to variable.

If you are interested in getting sheetname list, then follow this MSDN article.

Also here is the way to loop through Excel Files and Tables by Using a Foreach Loop Container

answered Jun 25, 2014 at 22:12

Vikramsinh Shinde

2,8832 gold badges26 silver badges30 bronze badges

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

1 Answer 1