Issue with bulk insert

Try ROWTERMINATOR = '0x0a'. it should work.

I got the same error message, and as you had mention, it was related to unexpected line ending. In my case the line ending was specified in a fmt file as a Windows Line ending (CRLF), written as \r\n, and the data file to process has a Mac classic one (CR).

I solved it with an editor that can show the current line ending and change it. I used EditPad Lite wich shows the opened file line ending in the bottom bar and pressing it allow to replace with the expected one.

This can also happen if the number of columns mismatch between the table and the imported file