Post reply

Foreach Loop not Looping

  • 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.  

  • 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:

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • September 7, 2017 at 1:32 pm

    #1958633

    Holy crap it worked.  Thank you so much!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply