Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS rounding decimals Expand / Collapse
Author
Message
Posted Monday, February 18, 2013 4:10 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 837, Visits: 2,460
Hi,

I am importing several csv files into a database. The CSV files contain data in a decimal format, accurate to 5 decimal places. I have added data sources for these csv files and given these fields DT_DECIMAL data type. In the database, the data type for the column receiving this data is decimal(18,5). However, something is rounding the values to whole numbers. For example, I get 125.00000 instead of the expected 125.2342.

Any ideas?

thanks, Andrew
Post #1421132
Posted Monday, February 18, 2013 4:15 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 837, Visits: 2,460
found that the datasource precision wasn't set. Thanks
Post #1421133
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse