August 31, 2007 at 12:29 am
Hi,
We are in a process of creating a POC on ETL operations for Unix-Oracle server. We are using SSIS for loading data into oracle db and we are also testing different 3rd party providers like persistant, datadirect, ETI..etc
While loading 1000k records into the table, our process is failing everytime with Microsoft provider or Oracle provider for OLEDB.
Plz see the error message :
"[OLE DB Destination [1882]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ROW-00060: Internal error: [dainsert,16]?|".
[OLE DB Destination [1882]] Error: The "input "OLE DB Destination Input" (1895)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (1895)" specifies failure on error. An error occurred on the specified object of the specified component.
[DTS.Pipeline] Error: The ProcessInput method on component "OLE DB Destination" (1882) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. "
Let me know if youhave nay suggestion .
Thanks
Sumit
August 31, 2007 at 8:25 am
Are you on 32-bit or 64-bit platform?
What type of Connection Manager are you using to write to Oracle?
September 1, 2007 at 7:03 am
we have windows server 2003 for SSIS and all providers are 32bit.
September 2, 2007 at 11:07 pm
What version of Oracle are you loading to, using which drivers?
Joe
December 18, 2007 at 12:13 pm
Did you solved the problem? I have the same situation and the same errors. Can you help me?
My windows is 2003 server, SQL 2005 with SP2, Oracle 9R2.
The provider for SQL is SQLNCLI and for Oracle OraOLEDB.
The error:
Error: 0xC0202009 at Data Flow Task, Destination - CHV_WRK_SEGURADO [61]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ROW-00060: Internal error: [dainsert,16]".
Error: 0xC0209029 at Data Flow Task, Destination - CHV_WRK_SEGURADO [61]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (74)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Destination Input" (74)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
Thanks in advance
Chiva
December 19, 2007 at 3:55 am
Have you checked the SSIS Connectivity whitepaper? They suggest using some ETI component for Bulk inserts to Oracle. See http://download.microsoft.com/download/2/7/c/27cd7357-2649-4035-84af-e9c47df4329c/ConnectivitySSIS.doc#_Toc158373716
If your solution/setup works for a smaller number of records (say 100k), it might be a workaround to use some loop container and load your data in chunks of 100k records.
Peter Rijs
BI Consultant, The Netherlands
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply