Hi, sorry my english. I'm not working in MS Sql long time. I make something in Enterprise manager. I need import data from txt file. This file hasn't fixed structure. The problem - after import by dts rows are not order as in txt file. I tried many ways but result is different. Rows aren't in order as in source txt - always different .
Thanks, Lubo

I forgot to write.. Import file is large 75 000 rows ! LuMa

If you have an primay key or clustered index in the table, that would chang the physical order of the table data.