I am using SQL Server 2014 Management Studio to import a very large
.CSV file into a table.
So far I have been trying to accomplish this by right-clicking on the database and selecting
Import Data, then using the wizard to import from a flat file.
The problem I am having is that every time I try to import I either run into truncation errors (some of my fields exceed
nvarchar(max)) or that there are missing fields on some rows.
How can I set the import to just ignore a failed row, instead of failing the entire operation. I've looked everywhere in the options but cannot find where to set this.