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.