sql server - SSIS Error Code DTS_E_OLEDBERROR 0x80004005

Question

I am running an SSIS package that uses OLEDB connections to fetch data from and Oracle 10.2.0.5.0 database and insert it into an SQLServer 2012 (11.0.6260)

I get the following error.

Time: 2021-02-05 01:13:55 AM
Task: Data Flow Task
Error Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.

followed by

Time: 2021-02-05 01:13:55 AM
Task: Data Flow Task
Error Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on OLE DB Source 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 stopped executing.  There may be error messages posted before this with more information about the failure.

There are no keys or constraints on the destination table.

Both of the dataflow tasks have CommandTimeout set to 0.

All of the other packages with the same source and destination databases run without any problem.

Edit 2

This particular package runs fine on our test/development environment.

I have sinced run the package several times and noticed that the source query returns about 4500 records but only about 500 are inserted into the destination database.

End Edit 2

Is there anything else that I can check for?

Edit 1

The Error message is as it appears in service manager.

The log files just before the error are below.

The source Query is quite along running query. It takes approximately 9 minutes.

End Edit 1

question from:https://stackoverflow.com/questions/66062200/ssis-error-code-dts-e-oledberror-0x80004005

Answer 1

Logging into the oracle database directly with the user that is used for our integrations and running the query gave the following error.

After increasing the size of the user profile the query returned data and the integrations ran correctly.