When I import a flat text file onto MS SQL Server through Data transformation Service, sometimes the order of rows in the table is the same as that of the text file, sometimes it's not, even if I did the exactly the same thing. That's really weird.

The bottom line is that I want to keep the original order of rows because I lost the identities of the records and need to merge two files based on the row order.

Can anyone help me on this? Thanks!

How did you confirm that the order changed? Did you open that table in EM or using query analyser? I would suggest you have an identity column in the destination table, and try to import data from the flat file except the identity column, thus you can see it in order that you find it in the flat file.

_________________________
- Vijay G
Strive for Perfection