| title | IBCPSession (Native Client OLE DB provider) | |
|---|---|---|
| description | IBCPSession (Native Client OLE DB provider) | |
| author | markingmyname | |
| ms.author | maghan | |
| ms.date | 03/14/2017 | |
| ms.service | sql | |
| ms.subservice | native-client | |
| ms.topic | reference | |
| helpviewer_keywords |
|
|
| apitype | COM |
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]
Important
[!INCLUDEsnac-removed-oledb-only]
The IBCPSession interface exposes support for [!INCLUDEssNoVersion] file-based bulk copy operations. The IBCPSession interface is exposed in the [!INCLUDEssNoVersion] Native Client OLE DB provider under the same level as Sessions. In the [!INCLUDEssNoVersion] Native Client OLE DB provider, data source objects are factories for Session objects, and bulk copy operations are specified in the connection property SSPROP_ENABLEBULKCOPY. In addition, the SSPROP_ENABLEFASTLOAD property should be set to true.
Calling the IDBCreateSession::CreateSession method will then result in the creation of a BulkCopySession object. All the file-based bulk copy methods exposed through the IBCPSession object are then callable with nearly similar signatures on this IBCPSession object's IBCPSession interface.
Note
The [!INCLUDEssNoVersion] Native Client OLE DB provider supports memory-based bulk copy operations through the IRowsetFastLoad interface.
For more information about using the [!INCLUDEssNoVersion] Native Client OLE DB provider for bulk copy operations, see Performing Bulk Copy Operations.
For a sample showing how to use the IBCPSession interface, see IBCPSession::BCPDone (OLE DB).
| Method | Description |
|---|---|
| IBCPSession::BCPColFmt (OLE DB) | Creates a binding between program variables and [!INCLUDEssNoVersion] columns. |
| IBCPSession::BCPColumns (OLE DB) | Sets the number of fields that are to be bound to the columns in a [!INCLUDEssNoVersion] table. |
| IBCPSession::BCPControl (OLE DB) | Sets the options for a bulk copy operation. |
| IBCPSession::BCPDone (OLE DB) | Commits the remaining rows to be sent to [!INCLUDEssNoVersion]. |
| IBCPSession::BCPExec (OLE DB) | Performs the bulk copy operation. |
| IBCPSession::BCPInit (OLE DB) | Initializes the bulk copy structure, performs some error checking, verifies that the data and format file names are correct, and then opens them. |
| IBCPSession::BCPReadFmt (OLE DB) | Reads format information for each column from the format file. |
| IBCPSession::BCPWriteFmt (OLE DB) | Writes format information for each column to the format file. |