Memory error

John Schroeder 1 Reputation point
2021-02-02T16:27:11.503+00:00

A buffer failed while allocating 205360000 bytes.
The Data Flow task failed to create a buffer to call PrimeOutput for output "ADO_SRC PROJECT" (2) on component "Output" (10). This error usually occurs due to an out-of-memory condition.
The system reports 24 percent memory load. There are 135871946752 bytes of physical memory with 103143043072 bytes free. There are 2147352576 bytes of virtual memory with 992673792 bytes free. The paging file has 155199299584 bytes with 121958596608 bytes free.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,468 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points
    2021-02-03T08:19:50.74+00:00

    Hi @John Schroeder ,

    Could you please divide the data into different groups?

    Please refer to Data Flow Performance Features and Improving data flow performance with SSIS AutoAdjustBufferSize property.

    Define the default size of the buffer that the task uses, by setting the DefaultBufferSize property, and define the maximum number of rows in each buffer, by setting the DefaultBufferMaxRows property. Set the AutoAdjustBufferSize property to indicate whether the default size of the buffer is calculated automatically from the value of the DefaultBufferMaxRows property. The default buffer size is 10 megabytes, with a maximum buffer size of 2^31-1 bytes. The default maximum number of rows is 10,000.

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.