How to dynamically set the ExcelFilePath when looping through different excel files in a data flow.
Scenario: I have many Excel files with a same format to convert to text files, and I have created a ForEach Loop to loop through each Excel file to have a data flow with an excel source to flat file. Question: How can I dynamically set the ...