• steve.alston - Tuesday, February 6, 2018 2:34 PM

    Thanks guys. So many responses and all pointing me the same way!

    My decision that I didn't need a loop was based on the single file process, but I guess the loop through a single file won't add much other than complication, and what I was trying was complicated and didn't even work!
    A for-each loop with variables I can handle!
    Thanks again guys.

    It's really not. I'm no SSIS expert either, but I remember reading one good article on how to loop through excel files one time and pretty much do it for every file I import, single or not. It's very easy to the point you should be able to do it by memory every time you make one.

    I would only note here, that you should also consider file validation with your processing. Don't just import any file in a directory. Validate it first, then start your process.