In previous version of SQL Server Integration Services (SSIS) Decimal
data type was not available for Variables. In SSIS 2012 Microsoft introduced
Decimal data type as shown in below snapshot.
![]() |
What is decimal data type variable in SSIS |
The value range that it can store is:
0 through
+/-79,228,162,514,264,337,593,543,950,335 with no decimal point;
0 through +/-7.9228162514264337593543950335 with
28 places to the right of the decimal; smallest nonzero number is
+/-0.0000000000000000000000000001 (+/-1E-28).
Confusion:
If we try to provide value greater than 79,228,162,514,264,337,593,543,950,335 it does throw an error. The value is too small or too large but if we provide smaller value than 0.0000000000000000000000000001 it does not throw any error. Later if we use the variable in expressions it will round the value for variable as shown in below snapshot.
![]() |
Decimal data type for variable in SSIS |
To see the value range for Variable data types , please visit
Nice post very helpful
ReplyDeletedbakings
Thank you Sudhir
ReplyDelete