Hi All,

I have an SSIS question regarding looping through CSV files with the Foreach Loop Container.

What I have:

  1. A string variable named fName - Global
  2. A Foreach Loop Container
    2.1 User::fName mapped to the loop container with an index of 0
  3. 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?

4 Years
Discussion Span
Last Post by Stuugie
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.