• I don't think it is SSIS, it is the SQL engine. Even though you read the file sequentially, where the rows wind up in the destination table is not guaranteed.

    (I got caught by it doing imports into MS Access from .txt files.)