July 8, 2008 at 7:00 pm
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.
December 27, 2012 at 12:12 am
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.
December 27, 2012 at 4:14 am
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 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply