SQL server Import CSV file - 1'st row is also added as s column name I'm trying to import a CSV file using import export wizard, Im facing an issue.
The first row is also added as a column name. 

Import wizard:



The highlighted area is my 1'st row.
I used your data and was able to do it without any issues. Seems your first row of data does not have {CR}{LF}. The snap of data looks like there is an auto new line rather than you providing it.And that is why the 3rd column has ' Is_Active""1, so the wizard is looking for a comma now. Below is my test with data of similar type :