AllowIdentityInserts Property (DTS)

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

Applies To

DataPumpTask Object

Syntax

object.AllowIdentityInserts[= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	Whether SET IDENTITY_INSERT is set to ON or OFF

Remarks

AllowIdentityInserts only applies to Microsoft® SQL Server™.

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetAllowIdentityInserts(VARIANT_BOOL *pRetVal);

HRESULT SetAllowIdentityInserts(VARIANT_BOOL NewValue);