I have a Simple Package that Loads Data from Oracle Table to Sql Server Table.
For Source Connection i have used (Oracle Connection) : ORACLE PROVIDER FOR OLEDB
and Destination: SQL SERVER NATIVE CLIENT 10.0
It just a Plain Insert of Record without any Transformation. But While executing , After Inserting "323750"
records , package gets failed at OLEDB SOURCE.
Error is as Follows:
1) SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
2) SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (200) 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 tried running package many times but after "323750" records it gets Failed. The Source (oracle) Table has around 20 Lakh reocrds.