November 6, 2012 at 4:17 am
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?
November 6, 2012 at 4:53 am
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 6, 2012 at 5:15 am
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.
November 6, 2012 at 5:34 am
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 6, 2012 at 5:41 am
coool....
thank you for your help.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply