Reference: MS SQL Server Extended Bulk Load Options
The Extended Bulk Load Utility for MS SQL Server is shown in the following image. It has the following options:
- *Commit every row(s)
-
Number of committed rows. This value should be a multiple of the Block size.
- Maximum number of errors
-
Maximum number of errors allowed before loading stops.
- Packet size to send
-
Packet size in bytes.
- Maximum Number of Load Sessions
-
Maximum number of load sessions logged on to the database.
- Maximum Number of Load Session Restarts
-
Maximum number of restart attempts after recoverable load session error.