Export (0) Print
Expand All
Expand Minimize

README How to bulk copy data using IRowsetFastLoad (OLE DB)

SQL Server 2005

Updated: 17 July 2006

Illustrates the use of IRowsetFastLoad for bulk copying of the records into a table. This sample is not supported on IA64.

For more information on this sample, see How to: Bulk Copy Data Using IRowsetFastLoad (OLE DB) in Books Online.

This sample uses Visual C++.

Before running this sample, make sure the following software is installed:

  • This sample connects to your computer's default SQL Server instance. To connect to a named instance, change this line WCHAR g_strTestLOC[100] = L"localhost"; to WCHAR g_strTestLOC[100] = L"machine_name\named_instance";. By default, SQL Server Express installs to a named instance.
  • The sample requires you to execute the following stored procedure, which you can find in the sample's scripts directory:
    USE AdventureWorks
    GO
    
    IF EXISTS (SELECT name FROM sysobjects WHERE name = 'IRFLTable')
         DROP TABLE IRFLTable
    GO
    
    CREATE TABLE IRFLTable (col_vchar varchar(30))
    
    In SQL Server Management Studio, load and execute the Scripts\setup.sql script or execute the following command in a Command Prompt window:
    sqlcmd -E -I -i Scripts\setup.sql
    
  • If you are using Visual Studio, load the BulkCopyRecords.sln file and build it.
  • If you are using MSBuild.exe, invoke MSBuild.exe at a command prompt, passing it the BulkCopyRecords.sln file:
    MSBuild BulkCopyRecords.sln
    

From Visual Studio, invoke Start Without Debugging (CTRL+F5).

If you built with MSBuild.exe, invoke BulkCopyRecords.exe.

Change History

Release History

17 July 2006

Changed content:
  • Clarified and updated prerequisites including the Web site for downloading the samples.
New content:
  • Added information on connecting to a named instance.

Community Additions

ADD
Show:
© 2014 Microsoft