UseBulkCopyOption Property
The UseBulkCopyOption property determines whether the select into/bulkcopy option is turned on automatically when the ImportData method of the Table object is executed.
Applies To
| BulkCopy Object |
Syntax
object.UseBulkCopyOption [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetUseBulkCopyOption(LPBOOL pRetVal);
HRESULT SetUseBulkCopyOption(BOOL NewValue);
Remarks
If TRUE, and the select into/bulkcopy database option is off in the target database, the option is turned on before an ImportData bulk copy is started and is turned off after the bulk copy is complete.
If FALSE, no adjustments to the database options are made.
Important The select into/bulkcopy database option allows bulk-logged alteration to the target database. A target database should be backed up after any bulk-logged actions against it. For more information, see Selecting a Recovery Model.