Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserver_fan
Starting Member
1 Post |
 Posted - 2010-08-05 : 09:53:33
|
| Hello All,I am using the Import/Export Wizard of SSIS to import data from Oracle 9I to SQL Server 2005 SP3. 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.Health & Happiness,Curtis White |
|
|
|
|
|
SQL Server 2005 SSIS Oracle Import Problem