Problems transfering 2000K lines from SQL to ORACLE

• adchiva

  Valued Member

  Points: 70

  More actions

  December 18, 2007 at 1:22 pm

  #121500

  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

  adchiva@terra.com.br

• sgambale

  SSCommitted

  Points: 1709

  More actions

  February 9, 2011 at 1:48 pm

  #1284817

  I get OLE DB provider "OraOLEDB.Oracle" for linked server "CPS001T.DB.ATT.COM" returned message "ROW-00060: Internal error: [dainsert,16]?w?Ubl?H?°.

  when attempting to insert > 20,000 rows from sql server 2005 to Oracle 10.2 using the oracle provider for oracle ole db.

  Did you resolve your problem?

  Steve