SSIS Error to use the oracle String

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS Error to use the oracle String

SSIS Error to use the oracle String

Rate Topic

Display Mode

Topic Options

Author

Message

crazy4learn

Posted Tuesday, July 08, 2008 7:00 PM

Grasshopper

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

santoooo

Posted Thursday, December 27, 2012 12:12 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, February 17, 2013 10:35 PM
Points: 83, Visits: 246

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

Phil Parkin

Posted Thursday, December 27, 2012 4:14 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:20 AM
Points: 4,242, Visits: 9,494

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 Smile

____________________________________________________________________________________________

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

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1400551

« Prev Topic | Next Topic »

Permissions