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

6 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