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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:02 AM
Points: 5,315, Visits: 12,344
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.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
Post #1400551
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse