cis bulk insert batch size

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


Range of values

0 – 2147483647



Display level


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.