Share via


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

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

Scenario

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

Languages

This sample uses Visual C++.

Prerequisites

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

Building the Sample

  • 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
    

Running the Sample

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.

See Also

Concepts

Data Access Samples

Help and Information

Getting SQL Server 2005 Assistance