A buffer failed while allocating 10469824 bytes. RRS feed

  • Question

  • Dear,

    I’m currently struggling with a this buffer issue.

    I already read many threads about this issue but I believe my situation is a bit different as no lookups are any complexity is done. My dataflow is simple, I have an OLEDB source that reads data from Oracle > a derived columns that adds a loadId > and a OLEDB Destination that pumps everything in a sql table using fast load.

    All settings are default.

    I’m receiving the following error messages (from time to time, not always !):

    A buffer failed while allocating 10469824 bytes.

    The system reports 30 percent memory load. There are 8588337152 bytes of physical memory with 5934104576 bytes free. There are 8796092891136 bytes of virtual memory with 8792947691520 bytes free. The paging file has 12728168448 bytes with 10493304832 bytes free.

    The attempt to add a row to the Data Flow task buffer failed with error code 0x8007000E.

    This is done using SQL 2008

    Thanks in advance!!


    Wednesday, June 17, 2015 7:14 AM

All replies