UseServerSideBCP Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Syntax

object
.UseServerSideBCP [= value]

Parts

  • object
    An 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.

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

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

Applies To:

BulkCopy Object

See Also

Other Resources

BULK INSERT (Transact-SQL)
Performing Bulk Copy Operations (ODBC)

Help and Information

Getting SQL Server 2005 Assistance