BULK insert truncation error

Strange data truncation problem runinng a BULK insert on SQL Server on LINUX?

BULK INSERT MyTable FROM 'my_table.csv' 
 WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '\n');

[S0001][4863] Bulk load data conversion error (truncation) for row 1, column 34 (my_column).

Try using the binary representation for the row terminator (e.g. 0x0a in place of \n).

BULK INSERT MyTable FROM 'my_table.csv' 
 WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '0x0a');

26 rows affected in 21 ms

For those who are asking, yes! You can run SQL Server on Linux.

#mssql #sql