ImportRowsPerBatch Property (SQL-DMO)

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

Applies To

Syntax

object.ImportRowsPerBatch [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	Long integer greater than 0

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.

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetImportRowsPerBatch(LPLONG pRetVal);

HRESULT SetImportRowsPerBatch(LONG NewValue);