Export (0) Print
Expand All

Enabling a Session for IRowsetFastLoad

SQL Server 2000

The consumer notifies SQLOLEDB of its need for bulk copy by setting the SQLOLEDB provider-specific data source property SSPROP_ENABLEFASTLOAD to VARIANT_TRUE. With the property set on the data source, the consumer creates a SQLOLEDB session. The new session allows consumer access to the IRowsetFastLoad interface.

Enabling a session for bulk copy constrains SQLOLEDB support for interfaces on the session. A bulk copy-enabled session exposes only the following interfaces:

  • IDBSchemaRowset

  • IGetDataSource

  • IOpenRowset

  • ISupportErrorInfo

  • ITransactionJoin (not supported for Microsoft® SQL Server™ version 6.5)

To disable the creation of bulk copy-enabled rowsets and cause the SQLOLEDB session to revert to standard processing, reset SSPROP_ENABLEFASTLOAD to VARIANT_FALSE.

Fastload sessions are not available with IDataInitialize (part of OLE DB service components).

To bulk copy data using IRowsetFastLoad


© 2015 Microsoft