UseServerSideBCP Property

SQL-DMO

SQL-DMO

UseServerSideBCP Property

The UseServerSideBCP property directs BulkCopy object behavior when implementing a bulk copy import operation.

Applies To
BulkCopy Object
Syntax

object.UseServerSideBCP [= 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 GetUseServerSideBCP(LPBOOL pRetVal);

HRESULT SetUseServerSideBCP(BOOL NewValue);

Remarks

The BulkCopy object can implement a data import operation using either the bulk copy extensions to ODBC or the Transact-SQL BULK INSERT statement.

When TRUE, the BulkCopy object specifies a row import operation implemented using the BULK INSERT statement.

When FALSE (default), the BulkCopy object specifies a row import or export operation using extensions to the SQL Server ODBC driver.

See Also

BULK INSERT

Performing Bulk Copy Operations