thanks for your time and reply
Check to see in your editor that it is reading the first 10 lines properly.
yes, its reading properly ..because my application doesn't break while those 370k records are loaded.
There's a chance that the text file doesn't have a carriage return line feed at the end of every row.
if it is so, how to check this and how to fix this ?
Are there empty rows in your source?
no, there no empty fileds text doc is from database. we are sure about this
Can you identify the missing rows?
no missing rows and all missing data is regarded as null