SqlBulkCopyOptions
Bitwise flag that specifies one or more options to use with an instance of SqlBulkCopy.
CheckConstraints = 2
Check constraints while data is being inserted. By default, constraints are not checked.
Default = 0
Use the default values for all options.
FireTriggers = 16
When specified, cause the server to fire the insert triggers for the rows being inserted into the database.
KeepIdentity = 1
Preserve source identity values. When not specified, identity values are assigned by the destination.
KeepNulls = 8
Preserve null values in the destination table regardless of the settings for default values. When not specified, null values are replaced by default values where applicable.
TableLock = 4
Obtain a bulk update lock for the duration of the bulk copy operation. When not specified, row locks are used.
When specified, each batch of the bulk-copy operation will occur within a transaction. If you indicate this option and also provide a SqlTransaction object to the constructor, an ArgumentException occurs.