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

Extracting Oracle data and loading to SQL server destination using SSIS Expand / Collapse
Author
Message
Posted Tuesday, November 6, 2012 4:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 3, 2014 5:09 AM
Points: 45, Visits: 111
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
Posted Tuesday, November 6, 2012 4:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Wednesday, December 24, 2014 6:46 AM
Points: 13,646, Visits: 11,524
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
Posted Tuesday, November 6, 2012 5:15 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 3, 2014 5:09 AM
Points: 45, Visits: 111
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
Posted Tuesday, November 6, 2012 5:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Wednesday, December 24, 2014 6:46 AM
Points: 13,646, Visits: 11,524
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
Posted Tuesday, November 6, 2012 5:41 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 3, 2014 5:09 AM
Points: 45, Visits: 111
coool....

thank you for your help.

Post #1381523
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse