SSIS Package was failing with error: The attempt to add a row to the data flow task buffer with error code 0x8007000E.

Sandra Morgado 5 Reputation points

Hi All,
Recently we migrated SQL Server from one server on perm to another on IBM cloud (virtual machine IaaS). An integral copy or image of the server was made to the cloud.

When we go to run some packages/jobs that run on perm but run in the new virtual machine, the following errors occur in some packages:

  • The attempt to add a row to the Data Flow task buffer failed with error code 0x8007000E.
  • A buffer failed while allocating 24480000 bytes.
  • SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on <DataFlow name> Source returned error code 0xC02020C4.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.

I have already changed some parameters in Data Flow

User's image

For testing have assigned 2TB ram as memory, IOPs have been increased

On system level performance, we don’t see the high utilization

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,824 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,084 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Sandra Morgado 5 Reputation points
    The packages that returned an error (buffer failed) I changed a property and now I can run them successfully.
    1 person found this answer helpful.
    0 comments No comments

  2. ZoeHui-MSFT 22,216 Reputation points

    Hi @Sandra Morgado,

    Please have a check if you are using the 32-bit mode.

    Also check this DBA StackExchange answer for some clues.


    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.