Tuesday, August 11, 2015

SSIS Buffer Size

DefaultBufferMaxRows – a DFT (Data Flow Task) property that specifies a maximum number of rows that can be held in an individual buffer. By default the value is set to 10,000, though this figure will be reduced if (based on row size estimates) the memory consumption would be greater than the DefaultBufferSize.

No comments:

Post a Comment