Aggregate Sum Round Off
-
Hi,
I am using Aggregate in a Dataflow. It is grouping the input on 3 fields and summing up a Decimal field on basis of that.
Now the final output of the Decimal sum is always getting Lower Rounded Off. Means -
If i am summing (10.2+12.8+2.6) the desired output is 25.6 but it is coming as 24.
Can any body help me?
Thanks in Advance
Aniruddha
-
W/O knowing too much about what your package looks like, it looks to me like you're pushing some kind of int data type. Try casting them as decimal or float before you do the math and see if that doesn't make the decimal stick.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
I gave a deep drive in it. It is not the problem of Aggregator. Now i am reading from CSV file using a Flat File Connection and inserting the output in to a SQL table using SQL Destination. it is converting all the decimal values into nearest integer.
Datatype in my SQL Table is Decimal.
The flat file value is -
0.2
1.3
2.8
The SQL Table Value (after execution of the SSIS Job)
0
1
2
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply