Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   SQL Server 2005 SSIS Import Problem (http://www.go4expert.com/forums/sql-server-2005-ssis-import-t22921/)

sqlserver_fan 4Aug2010 07:27

SQL Server 2005 SSIS Import Problem
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.

All times are GMT +5.5. The time now is 07:30.