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
ReplyDeleteWhile there are more classifications to AI, these two contains the center classifications. ExcelR Data Science Courses
ReplyDeleteI think there is a need to provide some more information about SSIS and many other utilities like these.
ReplyDeleteSSIS Upsert
Grateful to you, for sharing those superb expressive confirmations. I'll try to do around a spurring power in reacting; there's a striking course of action that you've crushed in articulating the important goals, as you charmingly put it. Keep Sharing
ReplyDeleteSQL Server DBA Training in Bangalore
This Was An Amazing ! I Haven't Seen This Type of Blog Ever
ReplyDeletecall girls in dehradun
This Was An Amazing ! I Haven't Seen This Type of Blog Ever
ReplyDeletecall girls in ghaziabad
This Was An Amazing ! I Haven't Seen This Type of Blog Ever
ReplyDeletecall girls in gurgaon
Liên hệ Aivivu, đặt vé máy bay tham khảo
ReplyDeletevé máy bay đi Mỹ bao nhiêu
vé máy bay từ houston về việt nam
giá vé máy bay đà nẵng hà nội
giá vé máy bay vinh tphcm
vé nha trang
bay về việt nam từ mỹ
bảng giá taxi sân bay nội bài
combo quy nhon