I am reading from a flat file using a flat file data source. That them passes the records on to a script tasks that parses the rows. The script assumes that the rows will come in, in the same order as they are in the text file. It is critical that the row are read in exactly the same order as they are in the flat file. Someone on my team said that SSIS will not guarantee the order of the records due to its multi threaded nature. I need to know if this is true or not. Is it safe to assume I will get the records read in the same order as they are in the flat file? If now, would I have to create a script to do the reading of the rows? Regards, Dave

The records are in "natural" order when extracted from the source file. But any subsequent transformation may alter the order of the records and/or buffers. If your source is directly connected to your script, it's safe to assume the records will be in "natural" order. Talk to me now on