cis bulk insert batch size determines how many rows from the source tables are to be bulk copied into the target table as a single batch using select into.
|
Summary Information |
|
|---|---|
|
Default value |
0 |
|
Range of values |
0 – 2147483647 |
|
Status |
Dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
Component Integration Services |
If you leave cis bulk insert batch size at 0, all rows are copied as a single batch. Otherwise, after the count of rows specified by this parameter has been copied to the target table, the server issues a bulk commit to the target server, causing the batch to be committed.
If a normal client-generated bulk copy operation (such as that produced by the bcp utility) is received, the client is expected to control the size of the bulk batch, and the server ignores the value of this configuration parameter.