Hi Everybody

I have some problem with the Bulk insert in Sql server 2008r2 i have 1 sample.txt file with 500000 records and all records are in Proper Sequence and insert into the database table like this.

Create Table sample (serialno varchar(max))

//----- Table Created--------//

Bulk insert sample From 'C:\Deno Range\sample.txt' WITH(KEEPIDENTITY, FIELDTERMINATOR = ',')

//----- Bulk Insert Complited ------//

view all data of table

Drop Table sample

//----- Table Deleted -----//

Do this process with same file more than 3 or 4 time Continuously

My Files data is like that

000001,56589587458585,20,03-18-2014

to

500000,56589587458585,20,03-18-2014

in proper sequence

its properly work 3 times but at 4 or 5th time when i use bulk insert command all data are successfully inserted into table but it lost the sequence.

after 1136th row 201545th row added and break all the sequence

Please Give me Proper Solution for that.