Post reply

SSIS rounding decimals

  • February 18, 2013 at 4:10 am

    #289665

    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

  • February 18, 2013 at 4:15 am

    #1588776

    found that the datasource precision wasn't set. Thanks

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply