Problem in Oracle 11G connection from SSIS Package

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Problem in Oracle 11G connection from SSIS Package

Author

Topic

boreddy
Posting Yak Master

172 Posts

Posted - 2011-09-13 : 02:10:40

We have oracle 11G R2 - 64 Bit on the machine and tried connecting to the Oracle 10G - 64 bit DB from SSIS package runs on 32-bit. We are getting below error message.

Description: 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: "Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.

Through SQL Plus we tried connecting from the server, it succeeds without any problem.

Could someone help me on this?

boreddy
Posting Yak Master

172 Posts

Posted - 2011-09-14 : 11:52:15

my server having the 64 bit oracle client so
i changed the oled db provider insted microsft oled db provider we used oracle provoder for OLEDB

now ia m able to connect the oracle data souce,
when i am runnning i am getting the below errors

Error: 2011-09-14 14:48:45.29
Code: 0xC02020F6
Source: Import Operators OLE DB Source [1]
Description: Column "NAME" cannot convert between unicode and non-unicode string data types.
End Error
Error: 2011-09-14 14:48:45.29
Code: 0xC02020F6
Source: Import Operators OLE DB Source [1]
Description: Column "FULL_NAME" cannot convert between unicode and non-unicode string data types.
End Error
Error: 2011-09-14 14:48:45.29
Code: 0xC02020F6
Source: Import Operators OLE DB Source [1]
Description: Column "EDS_CONTACT_NAME" cannot convert between unicode and non-unicode string data types
.
.
.
.
.

Error code 0xC0024107
Error: 2011-09-14 14:48:45.32
Code: 0xC004706B
Source: Import Operators SSIS.Pipeline
Description: "component "OLE DB Source" (1)" failed validation and returned validation status "VS_ISBROKEN".
The Execution method succeeded, but the number of errors raised (14) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number
specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

I think that is the validatin error

please advise me for this

it very urgent to me

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources