Thanks Frederico_Fonseca - can you do one small test for me and set the LASTROW to 1001 and test.  You will see why in my update below.   If the first...

• This reply was modified 2 years, 10 months ago by  railman.

yes, I have tested several files now and have found that even though the files come from the same source and look identical and have the same EOL Characters there...

the quote characters are double quotes.  I tried using FORMAT = 'CSV' but got these errors

Msg 4879, Level 16, State 1, Line 1

Bulk load failed due to invalid column value...

OK, I tried

WITH (FIRSTROW=2, LASTROW=1000, FIELDTERMINATOR=',', ROWTERMINATOR='\r', FIELDQUOTE='quote_characters');

But got the following error

Invalid quote character specified for bulk load. Quote character can be one single byte or Unicode character.

If you don't...

UPDATE

I copied the data lines only out of the file and created a new file and it successfully imported ( using \r)

Then i copied the header and several data lines...

I have tried \n \r \r\n and \t ,  none of them give me an error and say query completed successfully but 0 affected rows.

I have tried moving the file...

Here is a sample of the file

yes, it shows CRLF and I have tried changing it to both unix and mac using the EOL converter but no luck.