InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 17 Jun 2013 23:54:38 GMT20http://www.sqlservercentral.com/Forums/Topic1381484-148-1.aspxcoool....thank you for your help.Tue, 06 Nov 2012 05:41:04 GMTsubramani.rudrappa 78855http://www.sqlservercentral.com/Forums/Topic1381484-148-1.aspxI 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.Tue, 06 Nov 2012 05:34:24 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1381484-148-1.aspxHi,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).aspxit 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.Tue, 06 Nov 2012 05:15:29 GMTsubramani.rudrappa 78855http://www.sqlservercentral.com/Forums/Topic1381484-148-1.aspxHow 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.Tue, 06 Nov 2012 04:53:42 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1381484-148-1.aspxHi,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?Tue, 06 Nov 2012 04:17:26 GMTsubramani.rudrappa 78855