DTS – import txt files, no order rows , mixed rows | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS – import txt files, no order rows , mixed rows

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
Is is a comma-seperated or tab-delimeted file?
Post a sample of file output. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I forgot to write… Import file is large 10 Mb has 76 000 rows. I will try it send you it.
Post few rows here as a sample and rows aren’t that big to worry. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Are you importing in one new table?. Has that table any index?.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
]]>