SSIS Error to use the oracle String

• crazy4learn

  SSC-Addicted

  Points: 454

  More actions

  July 8, 2008 at 7:00 pm

  #123082

  HI all

  i m getting 1error when i connect my oracle Table using connection String

  when i click on table ,its display from the list but when i click on Preview Its give me error ...

  i cannot Use this table as source or destination.

  Other table are working good in same Schema,

  ERROR

  Error at Data Flow Task [OLE DB Destination [14]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

  An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Unspecified error".

  An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle error occurred, but error message could not be retrieved from Oracle.".

  An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Data type is not supported.".

  Error at Data Flow Task [OLE DB Destination [14]]: Opening a rowset for ""MY_TABLE_NAME "" failed. Check that the object exists in the database.

• santoooo

  SSCommitted

  Points: 1999

  More actions

  December 27, 2012 at 12:12 am

  #1571756

  Hi,

  I also had the same problem,

  In my table Timestamp column is there which is not supported by the OLEDB DESTINATION connection.

  Please cross check the data types in your table.

  --Santooo.

• Phil Parkin

  SSC Guru

  Points: 247125

  More actions

  December 27, 2012 at 4:14 am

  #1571805

  santoooo (12/27/2012)

  ---

  Hi,

  I also had the same problem,

  In my table Timestamp column is there which is not supported by the OLEDB DESTINATION connection.

  Please cross check the data types in your table.

  --Santooo.

  You just answered a four-year-old post! Let's hope the OP wasn't waiting that long

  ---