Mordred (5/15/2013)
I've been working on a workaround for this. I've created individual connections for each CSV file. At a certain point in my package, and while using precedence constraints for each table, I have been able to connect to each file individually for my ETL processes. the attachment sort of shows.
I think you're working along the right lines: check what sort of file it is and then execute the appropriate data flow - though I think I would have expected to see more things happening within the Foreach container.
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.