Specifies whether empty values should be interpreted as empty strings or as NULL.

Data Type

bool

Default Value

true

Remarks

This setting only affects SELECT statements when UseBulkAPI is set to true and BulkAPIVersion is set to v2.

By default, the provider pushes empty values returned from the BULK V2 API query operation as NULL. When PushEmptyValuesAsNull is set to false, empty values are instead pushed as an empty string for VARCHAR columns, 0 for numeric fields, and NULL for date fields.