Foreach Loop not Looping

• Luv SQL

  SSCommitted

  Points: 1544

  More actions

  September 7, 2017 at 1:04 pm

  #339694

  Here's what I was expecting my SSIS to do:
  Go to a folder and grab any csv file with the name "Summary" in it, import them into a SQL table, then move those files to an archive folder.

  What it's doing:
  Goes to the folder, grabs the first csv with Summary in the name, imports it, archives it, then stops.  There are 4 files with Summary in its name.  

  It must be something relatively simple that I'm missing as it's working sort of?  I've read that I don't need the arrow from the loop so tried removing that as well but it still only does the single file.  Works fantastic if I only had 1 file!

  All screenshots attached.  

• Phil Parkin

  SSC Guru

  Points: 247161

  More actions

  September 7, 2017 at 1:18 pm

  #1958632

  You need to move the data flow and file system task so that they are inside the foreach loop.
  This sort of thing:
  

  ---

• Luv SQL

  SSCommitted

  Points: 1544

  More actions

  September 7, 2017 at 1:32 pm

  #1958633

  Holy crap it worked.  Thank you so much!!