1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SQL Server 2005 SSIS Import Problem

Discussion in 'SQL Server' started by sqlserver_fan, Aug 4, 2010.

  1. sqlserver_fan

    sqlserver_fan New Member

    Aug 4, 2010
    Likes Received:
    Trophy Points:
    Database Administrator
    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.

Share This Page