I am using SSIS to import data from Oracle 9I to SQL Server 2005. I am using Microsoft OLE DB Provider for Oracle and Microsoft OLE DB Provider for SQL Server. Since I have had some truncation issues in the past, I am mapping Oracle Number to Numeric(38,16) In the SSIS Package. I am showing a discrepancy on some of the Oracle columns that are using the NUMBER data type when precision and scale is not specified. As an example, on one of the rows I imported a column called current_rate. Current_rate displays as 0.681728317630858 when selected in SQL Server Mangement Studio. The same row in Oracle displays the current_rate as .681728318 in both SQL Plus and Toad. I'm hoping someone with expertise in SSIS and Oracle can help me resolve this issue.
