Why doesn't MSSQL read csv from Asterisk?

Question

Asterisk

Good afternoon.
A csv file was generated from the asterisk. In mssql, I'm trying to write it to a temporary table as usual

CREATE TABLE #Ankets (card_number varchar(max),
name varchar(max),
phone varchar(max),
email varchar(max))
BULK INSERT #Ankets
FROM 'E:\calls-20170118.csv'
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = ',', --CSV field delimiter
ROWTERMINATOR = '\n', --Use to shift the control to next row
ERRORFILE = 'E:\qqqserror.csv',
TABLOCK
)

But the result is null. If I open this file in Excel 2007 and immediately save it, the data is transferred to the school. How to overcome this trouble?

Answer 1

Encoding and line breaks are different