November 23, 2017 at 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
November 23, 2017 at 10:47 am
river1 - Thursday, November 23, 2017 10:01 AMDear 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
😎
November 23, 2017 at 11:08 am
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
November 28, 2017 at 6:29 am
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