Specifies how the provider handles rows that do not match the expected structure based on the column headers.

Possible Values

Data Type

string

Default Value

"FALSE"

Remarks

This property applies when IncludeColumnHeaders is set to true. It determines whether and how the connector ignores rows that have missing or extra cells compared to the header row.

When this property is set to true, the connector ignores any row that does not match the expected number of columns. When set to false, all rows are included, even if incomplete.

You can also use the following modes for finer control:

• EXTRA: Ignores rows that contain more cells than expected.
• MISSING: Ignores rows that contain fewer cells than expected.

This property is useful for controlling how the connector processes irregular or malformed rows in text files during import.