DTS Programming

AllowIdentityInserts Property

The AllowIdentityInserts property specifies whether the SET IDENTITY_INSERT Transact-SQL statement is set to ON before and OFF after the data pump execution.

Applies To

DataPumpTask Object

DataPumpTask2 Object

Syntax

object.AllowIdentityInserts[= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	Boolean that specifies whether SET IDENTITY_INSERT is set to ON during data pump execution

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetAllowIdentityInserts(VARIANT_BOOL *pRetVal);

HRESULT SetAllowIdentityInserts(VARIANT_BOOL NewValue);

Remarks