Edit

Share via

IRowsetFastLoad (OLE DB)

  • Article

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Download OLE DB driver

The IRowsetFastLoad interface exposes support for SQL Server memory-based bulk-copy operations. OLE DB Driver for SQL Server consumers use the interface to rapidly add data to an existing SQL Server 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.

In This Section

Method Description
IRowsetFastLoad::Commit (OLE DB) Marks the end of a batch of inserted rows and writes the rows to the SQL Server table.
IRowsetFastLoad::InsertRow (OLE DB) Adds a row to the bulk copy rowset.

See Also

Interfaces (OLE DB)
Bulk Copy Data Using IRowsetFastLoad (OLE DB)
Send BLOB Data to SQL SERVER Using IROWSETFASTLOAD and ISEQUENTIALSTREAM (OLE DB)