Posts Tagged ‘IOpenRowset’

How to bulk copy data using IRowsetFastLoad (OLE DB)

  The consumer notifies SQLOLEDB of its need for bulk copying by setting the SQLOLEDB provider-specific property SSPROP_ENABLEFASTLOAD to VARIANT_TRUE. With the property set on the data source, the consumer creates a SQLOLEDB session. The new session allows the consumer access to IRowsetFastLoad. To bulk copy data into a SQL Server table Establish a connection to the data source. ... Full story

Copyright © 2010 Way2solve. All rights reserved.