Share via

Package failure due to physical memory and paging file

dinesh 41 Reputation points
2021-01-30T12:01:18.977+00:00

Hi, When I run my package am getting an error.

Error: The system reports 79 percent memory load. There are ..... (some number) bytes of physical memory with (some number) bytes free. There are (some number) bytes of virtual memory with (some number) bytes free. The paging file has (some number) bytes with (some number) bytes free.

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The primeoutput method on src_dft returned error code 0xC0202020C4.

I made changes to Rows per batch = 10000 and
Maximum insert commit size = 100000 on "oledb destination" task

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,461 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim Young 1 Reputation point
    2021-01-30T16:40:24.43+00:00

    I'm not convinced that the error you are experiencing is due to memory pressure. Are there other error messages in the log?

    0 comments
  2. Monalv-MSFT 5,896 Reputation points
    2021-02-01T07:07:32.03+00:00

    Hi @dinesh ,

    1.Could you please share the screenshots of components in Data Flow Task?

    2.Please set Rows per batch as -1 and set Maximum insert commit size as 2147483647.
    Rows per batch

    Specify the number of rows in a batch. The default value of this property is *-1****, which indicates that no value has been assigned.*
    ***Maximum insert commit size*
    Specify the batch size that the OLE DB destination tries to commit during fast load operations. The value of 0 indicates that all data is committed in a single batch after all rows have been processed.

    A value of 0 might cause the running package to stop responding if the OLE DB destination and another data flow component are updating the same source table. To prevent the package from stopping, set the Maximum insert commit size option to 2147483647.

    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.