I have an SSIS question regarding looping through CSV files with the Foreach Loop Container.
What I have:
- A string variable named fName - Global
- A Foreach Loop Container
2.1 User::fName mapped to the loop container with an index of 0
- A Data Flow Task
3.1 a CSV Connection
3.2 (and this is where I'm lost) An Expression @[User::fName] but I don't know what to set the Property to for this. IF this was an Excel file I would ExcelFilePath Property but since it isn't I'm at a loss.
Can anyone advise?