This is an SSIS 2017 issue using a Flat File Destination.
We pull the data from an OLD DB Source, run the column through a Sort Transformation and send the result to a Flat File Destination.
In all my testing I’m finding that the order in the resultant text file is correct.
I’ve used up to one million rows of random data and the sort order is always correct.
My boss, who has used SSIS for many years, says that this is not guaranteed because of the buffering of data in SSIS and we will have to use a scripting method to guarantee the sort order in the test file.
Do any of you know if this is true or not, or perhaps in older versions it was true, but this has been fixed.