I have an SSIS package written in 2008, and I would like to use the foreach to read flat files from a directory one by one.
However, I want to pull the files through the foreach loop in a very specific order. It's not alphabetical.. One of the files has to go first, then the others.
Other than having that one file to go first before the foreach loop, and then process the others, is there a way in that one foreach loop to specify the order of the files?
For instance, can I read the filenames into a recordset, then have the foreach loop read from that recordset in a specific order?