title: Maximum row-size exceeds in sql server error
body: <p>Recently one of out <code>SSIS packages</code> failed due to below error. </p>
  
  <blockquote>
    <p>"Cannot create a row of size 8208 which is greater than the allowable
    maximum size of 8060"</p>
  </blockquote>
  
  <p>I understood this is because the row-size is exceed the limit. Could someone please clarify the below questions</p>
  
  <ol>
  <li>We found there are 650 records in the table which exceeds the <code>row-size</code> limit. How sql server allows to insert these <code>records.</code> (we have the issue in two packages but only one is failing.)</li>
  <li>Is there any factors other than row-size causes the failure?</li>
  <li>what is the best possible solution for this issue?</li>
  </ol>
  
  <p>thanks for the help</p>