December 10, 2007 at 8:40 am
I have an Oracle table with a numeric field which holds currency data. If I do DESC(tablename) in SQL*Plus I see the field defined as NUMBER. When I use an SSIS package to import the data using the OLEDB provider for Oracle, it's brought in as numeric(38,0) and rounds off all the decimal points. How do I stop this happening?
Scott
--
Scott
December 10, 2007 at 10:05 am
Hi Scott,
Right click on the OLEDB Source and click on the Advanced Editor.
On the Advanced Editor dialog click on the Input and Output Properties tab.
Open the OLE DB Source Ouput node and then the Output Columns node.
Click on the colunm to change and sect the scale and precision properties under the Data Type Properties on the right pane.
Norman
DTS Package Search
December 10, 2007 at 10:40 am
Fantastic - thanks!
Scott
--
Scott
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply