UseServerSideBCP Property (SQL-DMO)

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

Applies To

Syntax

object.UseServerSideBCP [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	True or False

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 that will be implemented by 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.

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetUseServerSideBCP(LPBOOL pRetVal);

HRESULT SetUseServerSideBCP(BOOL NewValue);