title: Default Buffer Max Size and Default Buffer Size in SSIS
body: <p><img src="https://i.stack.imgur.com/S8huB.jpg" alt="enter image description here"></p>
  
  <p>Is there any relationship between Default Buffer Max rows and Default Buffer Size in SSIS.
  How to supply values to these property parameters?</p>
  
  <p>I mean is there any propossionality in between these ?If I double the buffer size double then can i also have to make the max rows to double?
  ssis experts please answer..</p>
  
  <p>Here the Oledb source contain 20 million records ,and also the lookup table.I have designed the dataflow with the mentioned buffersize and buffer rows.</p>
  
  <p>Is this the maximum size set up for all the components under the dataflow task?
  or is it like once the Lookup completes then it releases the buffer for the next component?</p>
  
  <p>I have doubled the size of buffer and the maxrows,but could not find any performance gain.</p>