Foreach Loop, Data Flow task buffer failed

Hot Topic

Help with IIf statement in expression
multiple-step ole db error
Access is denied: 'Interop.ADODB'.
Images on a report
raw file destination and environment variables
SQL installation Error...
Column-order an access speed?
SQL Server 2005 Sept CTP - Failed Installation - It Wants Disk 2????
AttachDbFilename, |DataDirectory| and SQL Server 2005 June CTP Relative Paths
how to get Alias name in columns and mapped column from views

SQL Server

loading to SQL Server
LDAP update from SQL Server
Connection Pooling
Can I create subscriptions programatically?
Transactional LOB replication error
How do create table from Excel (based on Excel column name) and import data from it?
Getting sample databases in Management Studio
Lookup including looking up on null values possible?
SQL Express uninstallation
Reusability in SSIS?

Foreach Loop, Data Flow task buffer failed

I have a package that runs fine by itself. But when I run it inside a Foreach Loop container on a parent package, I got a buffer error after a few loops. Here are a couple of the error lines:

A buffer failed while allocating 49085616 bytes.

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

I already played around with the Data Flow task’s DefaultBufferMaxRows and DefaultBufferSize properties, and I am still getting the error. Just wondering if there is a memory leak or something with the Foreach Loop task. I haven’t install SP1. Maybe SP1 fixes this issue



Answer this question

Foreach Loop, Data Flow task buffer failed

  • Karen Longstaff

    Could be that not the Foreach loop itself is leaking, rather one or multiple components inside that dataflow were the culprit.

    I highly recommend you install SP1 to see whether that helps, since I know there were some memory issues addressed in SP1.

    thanks

    wenyang



  • oopman

    I have SP1 installed and I have a similar issue. I do not get an error but the DataFlow hangs at 33 in OnProgress/Pre-execute event (Datacode=33 in sysdtslog90). My package executes another package from within the 'ForEach' loop. The child package contains the DataFlow task. When I run the child package standalone (i.e. not from the parent package containing the 'ForEach' loop) with the same variables as in the parent, the DataFlow works fine.
  • Foreach Loop, Data Flow task buffer failed
Answer this question