DTS Programming
KeepNulls Property
The KeepNulls property returns or sets a value indicating whether NULL columns should keep NULL values even if defaults exists on destination columns.
Applies To
| BulkInsertTask Object |
Syntax
object.KeepNulls [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to a BulkInsertTask object |
| value | A value indicating whether NULL columns keep NULL values |
Remarks
The default is FALSE, which causes the database to assign the default value upon insertion.
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetKeepNulls(VARIANT_BOOL *pRetVal);
HRESULT SetKeepNulls(VARIANT_BOOL NewValue);