Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  SSIS 2008 --Data Flow task buffer failed

Author  Topic  jkparsai Starting Member 1 Post Posted - 2008-12-30 : 09:10:09 My SSIS 2008 package simply extracts records from dource db to stage DB...nothing much just Lookup and Union all has been used.... It simply runs fine in Dev environment...But on Test environment package fails sometimes saying following error...records are in range of 35 to 40 million everyday.... --The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. --SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Read Contact Data" (318) returned error code 0xC02020C4. The component returned a failure codewhen 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. plesae suggest........