Member Avatar for Stuugie

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?

  • 1 Contributor
  • 1 Reply
  • 160 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by Stuugie
Member Avatar for Stuugie

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.