Out of Memory Error

John Schroeder 1 Reputation point
2021-02-02T16:30:51.99+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,525 questions
0 comments No comments
{count} votes

1 answer

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

    Hi @John Schroeder ,

    Please do not post the duplicate question.

    We will help you in another question.

    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.