Skip to content
v2.274.0

ColumnCountMismatchHandlingAction Enum ​

Identifies if the file contains less or more values for a row than the number of columns specified in the external table definition.

This property is only available for an uncompressed text file format.

Members ​

MemberDescription
DISABLEDColumn count mismatch handling is turned off.
FAILFail the query if the column count mismatch is detected.
SET_TO_NULLFill missing values with NULL and ignore the additional values in each row.
DROP_ROWDrop all rows that contain column count mismatch error from the scan.