title: Running SSIS packages in separate memory allocations or increasing the default buffer size?
body: <p>I have a SSIS package that has a child package that is failing. The error message isn't very helpful.</p>
  
  <blockquote>
    <p>The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020</p>
  </blockquote>
  
  <p>The problem seems to be I am running out of Virtual Memory to complete the job.</p>
  
  <p>I found a forum thread that may help solve the problem.  <a href="http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/d6d52157-0270-4200-a8c2-585fa9a0eed5/" rel="noreferrer">http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/d6d52157-0270-4200-a8c2-585fa9a0eed5/</a></p>
  
  <p>From the solutions offered I am unsure though how to:</p>
  
  <ol>
  <li>increase default buffer size</li>
  <li>Allocate a child pacakage into it's own memory allocation.</li>
  </ol>
  
  <p>I am running the package daily in SQL Server 2005.  I was running fine daily up until the 12th.  I am assuming the dat file that we are using to import data into the database grew to a size that was to large for the database to handle.  It's only a 8.90MB csv file though.  The import is a straight column to column import.</p>
  
  <p>The problem child package is step 1 and fails and continues and successfully completes the next 8 steps.</p>