I have a MAster Package callling 8 Dimension Package and 5 fact table packages.
Fact table Packages are in for eachloop. They have to loop 24 times during FirstRun
Each fact table load more than 500000 rows in every loop, and out of 5, two package loads more than million rows in every loop.
I got the following error message when the package was looping for the 23rd time. One of the five Fact table package failed with following error
DTS primeoutput failed returned error code 0xC02020C4
SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Staging Table "(1) 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.
After when I ran package explicitly, it ran well
Please help on what to be done to avoid this error and what does this error mean?.
I am Using SQL Server 2008, i5 Processor, 3.42GB RAm, DefaultBufferMaxRows = 10000
and Default BufferSize 10MB, EngineTHread=10
View Complete Post