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.
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...