steve.alston - Tuesday, February 6, 2018 2:34 PM
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.