Extracting Oracle data and loading to SQL server destination using SSIS

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 » Extracting Oracle data and loading to SQL...

Extracting Oracle data and loading to SQL server destination using SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

subramani.rudrappa 78855

Posted Tuesday, November 06, 2012 4:17 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 17, 2013 8:28 AM
Points: 40, Visits: 89

Hi,

I was going through extraction of oracle data using OLEDB source/connection.
I could see we cannot extract oracle data having data types NCHAR,NCHAR2 etc as OLEDB does not support it.

how to over come this? how to read oracle data having columns with these data types?

Post #1381484

Koen Verbeeck

Posted Tuesday, November 06, 2012 4:53 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 7:39 AM
Points: 9,370, Visits: 6,467

How are you so sure OLE DB doesn't support it?
What errors do you get?

It might be necessary to edit the mapping files located in C:\Program Files\Microsoft SQL Server\100\DTS\MappingFiles.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1381497

subramani.rudrappa 78855

Posted Tuesday, November 06, 2012 5:15 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 17, 2013 8:28 AM
Points: 40, Visits: 89

Hi,

Actually i have not build any SSIS package yet,i was going through the deatils in google to check how to read Oracle data using OLEDB source.
http://msdn.microsoft.com/en-us/library/windows/desktop/ms719652(v=vs.85).aspx

it was mentioned like we cannot use tables having few datatypes.So i thought of checking with the ppl if they have faced any issues hadnling these datatypes.

Post #1381511

Koen Verbeeck

Posted Tuesday, November 06, 2012 5:34 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 7:39 AM
Points: 9,370, Visits: 6,467

I think you're looking at outdated documentation. It talks about Oracle 7.3 and Oracle8.
Oracle is now at version 11.
The documentation is also about the deprecated Microsoft OLE DB provider for Oracle, which is not available in 64-bit.

It's recommended to use the Oracle OLE DB provider instead.

edit: there are some datatypes in the list marked as "not supported", while I'm sure I have already imported them with SSIS, so the list is definately outdated.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1381522

subramani.rudrappa 78855

Posted Tuesday, November 06, 2012 5:41 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 17, 2013 8:28 AM
Points: 40, Visits: 89

coool....

thank you for your help.

Post #1381523

« Prev Topic | Next Topic »

Permissions