SSIS Foreach Loop Container Not Looping through Excel Files

From the first image, it looks like you have set the Variable ExcelFileName to be evaluated as Expression since the expression mark (fx) is shown on the variable icon:

enter image description here

Just remove the expression from the variable and check that the EvaluateAsExpression property is set to False

Tags:

Sql Server

Excel

Ssis

Etl

Foreach Loop Container

Related

With Swift 5 and iOS 12.2+ should I change "Always Embed Swift Standard Libraries" to NO? Copy files to local from multiple directories in HDFS for last 24 hours Center component inside the material-ui grid Making a dotted grid with CSS Timed out receiving message from renderer: 10.000 while capturing screenshot using chromedriver and chrome through Jenkins on Windows How do you add a Curves class animation to AnimationController in Flutter? Since upgrading to Xcode 10.2 I can no longer run react-native run-ios through the cli Sort a Julia 1.1 matrix by one of its columns, that contains strings Bootstrap 4.3.1 Popover Does Not Display Table Inside Popover Content Rename nested struct columns in a Spark DataFrame After updating to Xcode 10.2: Invalid Toolchain error when trying to submit app to App Store How to implement drag and drop in cypress test?

Recent Posts