Koen Verbeeck (8/27/2013)
Yes, there's a FOR loop, but I don't think you can specify a fixed order. (hence my suggestion for .NET where you have more control)
Hey, I never said SSIS was perfect ;-)
I've created several packages for SSIS which look for the most recent file in a directory, and I've never found a way other than using a .NET script, or at least not one that isn't as much if not more work.
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.