Gewtting this Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005

0

I am creating a new SSIS package, about 25 data flows. From Oracle database to SQL Server. IT fails 7 out of 10 times. I'm constantly getting these two errors:

[Pull FCST [28]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Pull FCST 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.

I am also getting this warning:

[SSIS.Pipeline] Information: The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 0 buffers were considered and 0 were locked. Either not enough memory is available to the pipeline because not enough is installed, other processes are using it, or too many buffers are locked.

Any ideas to what can be done? I've changed the Run64BitRuntime to false, but still getting the same error

sql-server
oracle
ssis
ssis-2019
asked on Stack Overflow May 11, 2021 by Roostam Sagdoul • edited May 11, 2021 by Dale K

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0