Bulk Insert CSV into a SQL Server table is a common task for SQL developers and DBAs. Normally a large file is used as a source of delimited data. A useful feature of BULK INSERT is the ERRORFILE argument.

The ERRORFILE records rows with formatting issues. The BULK INSERT process copies the rows into the error file. As well as the log file created to report the rows , another file is created , with the .ERROR.txt suffix, whose purpose to report on the error reasons .