This option is enabled when we are
selecting Data access mode to “Table or view – fast load”
The
default value for this setting is '2147483647' (largest value for 4 byte
integer type) which specifies all incoming rows will be committed once on
successful completion. We can specify a positive value for this setting to
indicate that commit will be done for those number of records. Changing the
default value for this setting will put overhead on the dataflow engine to
commit several times. Yes that is true, but at the same time it will release
the pressure on the transaction log and temp DB to grow specifically during
high volume data transfers.
Thanks for your information, it was really very helpfull..
ReplyDelete