September 7, 2017 at 1:04 pm
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
You need to move the data flow and file system task so that they are inside the foreach loop.
This sort of thing:
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
September 7, 2017 at 1:32 pm
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