AseBulkCopyOptions Enumeration

Specifies the available behavior options for the AseBulkCopy class.

Syntax

enum AseBulkCopyOptions

Members

Member name

AseBulkCopy behavior

CheckConstraints

Checks constraints while during an insert operation.

Default

By default, all options are off.

FireTriggers

Informs the server to fire triggers during an insert operation.

KeepIdentity

Uses the identity values of the data source. If the KeepIdentity is not selected, Adaptive Server assigns the identity.

KeepNulls

Inserts null values. If KeepNulls is not selected, default values replace null values.

TableLock

Locks the entire table during the bulk copy operation.

UseInternalTransaction

If set, each batch of the bulk copy will be in a transaction.