Export (0) Print
Expand All
Expand Minimize

ImportRowsPerBatch Property

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.


object
.ImportRowsPerBatch [=value]

object

An expression that evaluates to an object in the Applies To list

value

A long integer greater than 0

Long

Read/write

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

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.

Other Resources

Batches

Help and Information

Getting SQL Server 2005 Assistance
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft