I am trying to run the following:
BULK INSERT nashvilleHousing
FROM 'C:\Users\Bruce\Downloads\Nashville Housing Data for Data Cleaning (2).csv'
WITH (
FIRSTROW = 2,
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
);
To insert the following CSV data:
I get the following repeating error:
Msg 4864, Level 16, State 1, Line 35
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 4 (SalePrice).
This extends downwards to all rows in the original file (so row 3, column 4; row 4, column 4; etc....)
I have tried changing ROWTERMINATOR and FIELDTERMINATOR, and scanning the source data for errors. No luck.

