SSIS rounding number to 2

Question

I have a column of type DT_NUMERIC(16,4). How can I round to number to 2 digits is SSIs in derived column? I tried sound(column,2) and it doesnt work for me.

I have also tried (DT_NUMERIC,16,4)ROUND([Column],2) , it doesnt work either

Currently I have = 21.7000 I want = 21.70

Yahfoufi · Accepted Answer · 2017-06-05T15:15:59.350

0

Just try casting to (DT_NUMERIC,16,2), use the following expression:

(DT_NUMERIC,16,2)ROUND([Column],2)

Also you can try this:

ROUND(((DT_NUMERIC)([Column])), 2)

Or

(DT_DECIMAL,2)[Column]

edited Jun 05 '17 at 15:15

answered Jun 05 '17 at 14:55

Yahfoufi

2,220
1
22
41

Hi Yahfouhi.Thanks for reply but both of them dont work . I really need to get it done.. – Kate Jun 05 '17 at 15:04
@Kate try `(DT_DECIMAL,2)[Column]` – Yahfoufi Jun 05 '17 at 15:16
@kate i am waiting for a reply – Yahfoufi Jun 05 '17 at 15:43
Wait I have to run after I do something on my pkg. – Kate Jun 05 '17 at 15:49
(DT_NUMERIC,16,2)ROUND([Column],2) works for me... thanks a lot – Kate Jun 05 '17 at 15:55

SSIS rounding number to 2

1 Answers1