This topic has not yet been rated - Rate this topic

ImportRowsPerBatch Property

SQL Server 2008 R2

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The ImportRowsPerBatch property specifies the number of rows contained in a bulk-copy transaction.

Syntax

Copy


object
.ImportRowsPerBatch [=value]

Parts

object: An expression that evaluates to an object in the Applies To list
value: A long integer greater than 0

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

Copy

HRESULT GetImportRowsPerBatch(LPLONG pRetVal);
HRESULT SetImportRowsPerBatch(LONG NewValue);

Remarks

The Microsoft SQL Server bulk-copy process can copy large amounts of data from an external data file to a SQL Server table. By default, a bulk-copy data-import operation inserts all rows in the data file in a single transaction. SQL Server does not guarantee data integrity until and unless a bulk-copy transaction is committed.

Use ImportRowsPerBatch to adjust the size of the bulk copy transaction.

Applies To:

BulkCopy Object

Concepts

Batches

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ