How to fix "Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED

Question

Hi Every one I just want to ask what kind of Error is This, I can't find Best Solution on Google

When I try ODBC to OLEDB
AND OLEDB to OLEDB connection

ODBC to OLEDB - Failed ,While OLEDB to OLEDB - Sucess

but when I check the flow inside, 516069 out of 546009 completed, some data not been populated

and error message was

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on ODBC Source returned error code 0x80004005.  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.

Does anyone know what kind of error is this and best way to resolved this.

Answer 1

I can't find Best Solution on Google

The "best solution" rarely exists and to get a working solution at all, you have to provide much more details&information about your existing solution; the screenshot as it are more then useless.