GSquared,

How do I manually assign it to each row?

Thanks

I tried using this line via a stored procedure ,the records were still mixed up..

bulk insert Data from 'C:\SQLData\Import\P11.dat' with (fieldterminator = '', rowterminator ='\r',rows_per_batch =1)

Is this incorrect? It...

I'll try with the IDENTITY column, since I am using Option # 2, to see if it helps... Thanks,