SSIS : Rounding a numeric value

  • Dear all,

    I have a numeric value in SSIS like = numeric 28,14 and I have created a new derivated column to try to round it to numeric 28, 12. I have tryed like this:

    ROUND([Data Conversion].Weight,12) but it does not work. Can someone help?

    Thank you

  • river1 - Thursday, November 23, 2017 10:01 AM

    Dear all,

    I have a numeric value in SSIS like = numeric 28,14 and I have created a new derivated column to try to round it to numeric 28, 12. I have tryed like this:

    ROUND([Data Conversion].Weight,12) but it does not work. Can someone help?

    Thank you

    Can you elaborate slightly further, rounding 28,14 to 28,12 is not withing the normal functionality of that function
    😎

  • I have a value like 0.22222222222222222 that I would like to round to numberic 28, 12

    So only 12 decimal places.

    Value is coming from excel, then I use a data conversation to convert it to 28, 24.

    So that I can read the value .

    After I would like to convert it 24, 12 because the database as the field as decimal 28, 12

  • Dear all,

    This is solved. I took a way a % value and I am ok now. So my mistake.

    Thank you very much for your time.

Viewing 4 posts - 1 through 3 (of 3 total)

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