I need to capture numeric values without truncation. But the output value is getting truncated even though I specified the Scale as '2'.
Column 'A' datatype - numeric(5,2)
Arithmetic overflow error converting varchar to data type numeric.
My question is why I am not receiving any error when the scale is higher than '2' but I am getting error when the precision is higher than 3.
I am facing this issue in SSIS Data Conversion task. I need to capture the rows which are truncated in another table. Simplified this question in this way for obvious reasons.