Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Error to use the oracle String Expand / Collapse
Author
Message
Posted Tuesday, July 8, 2008 7:00 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 22, 2008 7:21 AM
Points: 12, Visits: 296
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.

Post #530440
Posted Thursday, December 27, 2012 12:12 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, July 10, 2013 10:13 PM
Points: 83, Visits: 253
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.
Post #1400483
Posted Thursday, December 27, 2012 4:14 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:15 PM
Points: 4,950, Visits: 11,577
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



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1400551
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse