Decimal Data Type Variable in SSIS - SSIS Tutorial

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

7 comments:

  1. While there are more classifications to AI, these two contains the center classifications. ExcelR Data Science Courses

    ReplyDelete
  2. This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thankyou For Sharing, data science course

    ReplyDelete
  3. I think there is a need to provide some more information about SSIS and many other utilities like these.

    SSIS Upsert

    ReplyDelete
  4. This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thankyou For Sharing, data science course in Hyderabad

    ReplyDelete
  5. Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.

    Data Science In Banglore With Placements
    Data Science Course In Bangalore
    Data Science Training In Bangalore
    Best Data Science Courses In Bangalore
    Data Science Institute In Bangalore

    Thank you..

    ReplyDelete