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

Question

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

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

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

Answer 1

The packages that returned an error (buffer failed) I changed a property and now I can run them successfully.

Answer 2

Hi @Sandra Morgado,

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

Also check this DBA StackExchange answer for some clues.

Regards，

Zoe Hui

---

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