DTS Programming

KeepIdentity Property

The KeepIdentity property indicates whether the data in the file is used for the values of identity columns.

Applies To
BulkInsertTask Object

Syntax

object.KeepIdentity [= value]

Part Description
object Expression that evaluates to a BulkInsertTask object
value A value indicating whether the data in the file is used for the values of identity columns

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetKeepIdentity(VARIANT_BOOL *pRetVal);

HRESULT SetKeepIdentity(VARIANT_BOOL NewValue);

Remarks

The default is FALSE, which causes the database to assign values to identity columns upon insertion.

See Also

KeepNulls Property