I have the above message while trying to use bulk insert to load a flat file into SQL 2005.

After some investigation, I realized there is an additional EOF character at the end of file.

May I know how can I resolve this problem without manually "cleaning" the file by removing the EOF character?

Here is my Bulk Insert syntax:

BULK INSERT PHARMSRAW FROM ABC.TXT
WITH ( FIELDTERMINATOR = ',' , ROWTERMINATOR = '
' )

It has a funny row terminator. With the additional EOF character at the end of file, it really made the whole thing went crazy.

Any idea how to get it resolved? Thanks in advance!