0

I have a table with column values like 12.1, 12.8, 34.2 in this format. When importing these values into another table using SSIS, the values loaded into the destination table are being rounded down, like 12.0, 13.0, 34.0. How can I ensure the same values get loaded into the destination table as existed in the source table?

3N1GM4
  • 3,372
  • 3
  • 19
  • 40
Jata Thakur
  • 5
  • 2
  • ROUND(), and cast? – jarlh Dec 13 '16 at 09:44
  • Hey, I want to get the output as same as input. But it is rounding off in Destination table. Thanks – Jata Thakur Dec 13 '16 at 09:53
  • It would be helpful to see the schema (specifically column types) for the source and destination tables - are both fields of type `FLOAT`? – 3N1GM4 Dec 13 '16 at 10:18
  • My Source Field - convert(decimal(10,1),DATEDIFF(DAY, b.VALIDFROM,getdate())/365.25) and Destination table data type is [ServiceDuration] (decimal(10,1) NULL. I have tried converting the Data concersion to DT_R4 in SSIS Package also. Thanks – Jata Thakur Dec 13 '16 at 10:26
  • What is the data type of that column in the Output of your Source component? – Tab Alleman Dec 13 '16 at 14:01
  • Possible duplicate of [DT\_Decimal Data Type Cutting off Decimal](http://stackoverflow.com/questions/24518534/dt-decimal-data-type-cutting-off-decimal) – Tab Alleman Dec 13 '16 at 14:04

0 Answers0