Jeff Moden (8/27/2013)
Glad some things never change.I edited my post without realizing that you had responded. Isn't there some "For Each" loop that can get and loop through files in a certain order and just limit the number of iterations to 1?
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 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP