by Your question is similar to below:
"I throw a number of paper noted into a bag. I throw them sequentially. I then shake the bag.
When I now pick the notes out of the bag, I don't get the paper notes in the same sequence as
when I put them in the bag."
Rows in a table are not ordered. This is an important part of the relational model. Add another
column (IDENTITY perhaps) and have BULK INSERT generate a value for that column (assuming the
BULK INSERT has such an option, which I think it does).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...
> I have a text file with more than 1,00,000 rows. i want
> this text file to be loaded in the order of exists in the
> text file. But when i use the following code snippet, the
> bulk.txt file will be load into #Batch_101 table with some
> rows interchanged.
> This is my bulk insert statement.
> i am not creating any cluster index for this table. This
> table have only one column COL1 with varchar(100) as
> datatype.
> Anyone help me please...