Optimize throughput

. The Integration Service does not preserve row order when multiple partitions read from a single file source. Use this option if the order in which multiple partitions read from a file source is not important.

Keep relative input row order

. The Integration Service preserves the input row order for the rows read by each partition. Use this option to preserve the sort order of the input rows read by each partition.

Keep absolute input row order

. The Integration Service preserves the input row order for all rows read by all partitions. Use this option to preserve the sort order of the input rows each time the session runs. In a pass-through mapping with passive transformations, the order of the rows written to the target will be in the same order as the input rows.