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);