sqL table is sorted by default

Posted by Pramodtech on Stack Overflow See other posts from Stack Overflow or by Pramodtech
Published on 2010-04-15T05:25:48Z Indexed on 2010/04/15 5:33 UTC
Read the original article Hit count: 320

Filed under:
|

I have simple SSIS package where I import data from flat file into sql table(MS sql 2005). File contains 70k rows and table has no primary key. Importing is sucessful but when I open sql table the order of rwos is different from the that of file. After observing closely I see that data in table is sorted by default by first column. Why this is happening? and how I can avoid default sort? Thanks.

© Stack Overflow or respective owner

Related posts about sql

Related posts about ssis