Extracting data from two Oracle Source Systems A, B by using SSIS OLEDB Source Component. When extracting Number ( Numeric) data types from Source B, Scale value Set to Zero in Advanced editor's External Columns, even though explicitly casting the column CAST(col1 as NUMERIC(24,13)). But this not happening while extracting from Source System A. Yesterday found the issue Causing this problem, Oracle Client in my workstation to connect to Source System B is Oracle 10g, Source B is Oracle 9i, Source A is Oracle 10g. due to difference in Oracle versions ( Client and Server), this issue is arising . Any suggestions please, to solve this issue. Vj

Did you try using ADO.NET data source instead OLE DB?Thanks Ayyappan Thangaraj, http://SQLServerRider.wordpress.com

Hi Vj, Please take the following article as a reference, and hope it can help you. Using SSIS to get data out of Oracle: A big surprise: http://blogs.msdn.com/b/sqlperf/archive/2009/08/14/using-ssis-to-get-data-out-of-oracle-a-big-surprise.aspx Thanks, Eileen