IRowsetFastLoad (OLE DB)

 

System_CAPS_ICON_warning.jpg Warning

SQL Server Native Client (SNAC) is not supported beyond SQL Server 2012. Avoid using SNAC in new development work, and plan to modify applications that currently use it. The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Microsoft Azure SQL Database.

The IRowsetFastLoad interface exposes support for SQL Server memory-based bulk-copy operations. SQL Server Native Client OLE DB provider 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.

MethodDescription
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.

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

Community Additions

ADD
Show: