August 14, 2009 at 1:22 pm
Does anyone know why the decimal places get converted to zero in a data flow task with Oracle OLE DB Source to SQL Server OLE DB Destination?
For example 147.66 becomes 147.0000 and 0.015 becomes .0000.
I have tried data conversions between Source and Destination to Float, Currency, and Numeric (18.4) without success. I also get the same result going to a Flat File Destination.
The Oracle preview data shows the decimal places, however the data type appears to be Numeric (38,0) so the decimal places are getting lost in the transform.
I am using Native OLE DB - Microsoft OLE DB Provider for Oracle. Do I need to use Oracle's driver? If so, how do I make it available in SSIS?
Thanks in advance to anyone who can help with this!
August 14, 2009 at 1:33 pm
This is just a wild guess, but check your datasource to be sure SSIS is using the correct datatype on the read.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 14, 2009 at 1:44 pm
Thanks Alvin, I think you're right - when I add the Data Conversion object, the source columns show Numeric (38,0), but I don't know where to change this, do you? (a preview of the data from the Oracle source does show the decimal data correctly) Mary
August 14, 2009 at 1:53 pm
I don't have an open package in front of me so I may not use the correct wording.
2 places to look. Open the connection manager and look at the properties for that column. Also, right click on the data source and open the advanced editor. Look at that column there too, keeping in mind that there's more than one place where the column shows up.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply