| title | IRowsetFastLoad (OLE DB) | Microsoft Docs | |
|---|---|---|
| description | IRowsetFastLoad (OLE DB) | |
| ms.custom | ||
| ms.date | 06/14/2018 | |
| ms.prod | sql | |
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw | |
| ms.reviewer | ||
| ms.technology | connectivity | |
| ms.topic | reference | |
| apitype | COM | |
| helpviewer_keywords |
|
|
| author | pmasl | |
| ms.author | pelopes |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]
[!INCLUDEDriver_OLEDB_Download]
The IRowsetFastLoad interface exposes support for [!INCLUDEssNoVersion] memory-based bulk-copy operations. OLE DB Driver for SQL Server consumers use the interface to rapidly add data to an existing [!INCLUDEssNoVersion] table.
If you set SSPROP_ENABLEFASTLOAD to VARIANT_TRUE for a session, you cannot read data from rowsets subsequently returned from that session. When SSPROP_ENABLEFASTLOAD is set to VARIANT_TRUE, all rowsets created on the session will be of type IRowsetFastLoad. IRowsetFastLoad rowsets do not support rowset fetch functionality; therefore, data from these rowsets cannot be read.
| Method | Description |
|---|---|
| IRowsetFastLoad::Commit (OLE DB) | Marks the end of a batch of inserted rows and writes the rows to the [!INCLUDEssNoVersion] table. |
| IRowsetFastLoad::InsertRow (OLE DB) | Adds a row to the bulk copy rowset. |
Interfaces (OLE DB)
Bulk Copy Data Using IRowsetFastLoad (OLE DB)
Send BLOB Data to SQL SERVER Using IROWSETFASTLOAD and ISEQUENTIALSTREAM (OLE DB)