I am attempting to use a ForEachLoop Container to run through Various Excel Worksheet files and import them into SQL.
I had previously asked this question in a different thread. I thought I had it working but when re-opened the project I have not been able to get it to work. I have attached all the screenshots from the setup and the error message I get when I try and apply the variable to the Excel Source Data Flow.
If I manually enter the worksheet name into the variable value it works just fine. For some reason the ForEach loop editor is not populating the variable with the correct info. Any info on where I am going wrong would be greatly appreciated.