Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.

• ishaan99

  SSCertifiable

  Points: 6261

  More actions

  January 19, 2011 at 1:39 pm

  #149792

  I have an SSIS pckg which copies oracle data from source to destination. i am using OLEDB provider for Oracle to copy data . The source is OLEDB Source connection but destination is OLEDB sql command which does an insert into table values(,,,) some of the inserts work fine in my pckgs however i am running into issues with most of them. all of tehm failing with same error as

  Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "TableName Destination" (289) failed with error code 0xC0202009. 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.

  Not sure what setting need to change to avoid this error. any help wil lbe greatly appreciated.

  TIA

• Koen Verbeeck

  SSC Guru

  Points: 259125

  More actions

  January 20, 2011 at 12:23 am

  #1275711

  Are you copying data from Oracle to Oracle?

  If yes, why don't you use Oracle Migration Workbench?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP