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?

I set it as a Connection String and everything is A-OK now.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.