John Morehouse shows that there are more SSIS connection managers than meets the eye:
While recently examining an existing SSIS package before implementing some needed changes I noticed the connection manager for multiple flat files.
Normally, when processing multiple files, I use a sequence container and loop through them. It’s usually a cumbersome process to setup and you must configure variables. I was not aware the multiple flat file type of connection manager existed. No wonder because it’s notwithin the normal list. This handy thing could only be found when I looked under “New Connection”.
Click through for more details.
Perhaps a small demo on how to configure it would be nice. I have several packages that use multiple flat files, and it sure would be nice not to have to use loops and variables as you indicated.