Have you received such error? I’ve got in my SSIS package something like this:
“Hresult: 0x00040EDA Description: “Warning: Null value is eliminated by an aggregate or other SET operation.”. End Error Error: 2008-01-12 12:02:52.75 Code: 0xC0047038 Source: STR3c-sells DTS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component “OLE DB Source” (1) returned error code 0xC0202009. 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 sto… The package execution fa… The step failed.”
and I spent a lot of time to find the reason of such situation. In fact there’re two solutions. “Warning: Null value is eliminated by an aggregate or other SET operation” means that some of aggregated columns contain cells with null values. I use stored procedures in my package and package execution failed. So the best way is to remove cells with NULL. It’s also the best way to have database integrity. Second solution is use T-SQL query instead stored procedure (in my case) and put at the begin of query: “SET ANSI_NULLS OFF”. And with this option our job will execute without a problem.