I have a project that is pulling data from over 600 tables in Oracle to SQL Server 2008 using the Oracle CDC in SSIS 2008. I have divided the tables in to groups using the CDC Package creation wizard.

Two of my full load packages have fewer than 20 tables being loaded and they work fine.

When I attempt to run the full load packages that have a group of 30 or more tables I get buffer errors like this: "Full Load Data Flow,{ED92B4C9-6F20-407B-8DBF-E9DD1B0FB378},{49FAF6EC-A543-4387-9346-AC1A462957E6},3/4/2011 12:37:31 PM,3/4/2011 12:37:31 PM,-1071636284,0x,The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020."

I have tried allowing the wizard to define the defaultbuffersize and defaultbuffermaxrows and enginethreads settings as well as turning this off in the wizard and using the SSIS defaults for these settings. In addition, I have tried reducing the rows per batch and max insert commit size values on the destination of each table's data pump destination. None of these attempts have been successful.

I do not have these issues in manually created SSIS packages that pull simillar volumes of data from Oracle in SQL Server.

Is there an optimal number of tables or a set of data flow settings that I can modify to ensure these Wizard generated Attunity packages complete successfully?