title: A buffer failed while allocating 10484320 bytes
body: <p>When I run the following package, it completes every task successfully until loading into the destination where 0 rows are written. I reduced the buffer size but still didn't work.
  Any clue on how to solve this. I get the following error messages</p>
  <blockquote>
  <p>&quot;A buffer failed while allocating 10484320 bytes&quot;, &quot;SSIS Error Code DTS_E_PROCESSINPUTFAILED&quot;</p>
  </blockquote>
  <p><a href="https://i.stack.imgur.com/yyUWl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yyUWl.png" alt="enter image description here" /></a></p>