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
| Member | Description |
|---|---|
DISABLED | Column count mismatch handling is turned off. |
FAIL | Fail the query if the column count mismatch is detected. |
SET_TO_NULL | Fill missing values with NULL and ignore the additional values in each row. |
DROP_ROW | Drop all rows that contain column count mismatch error from the scan. |