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:
September 7, 2017 at 1:32 pm
Holy crap it worked. Thank you so much!!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy