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

12 comments:

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

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

    SSIS Upsert

    ReplyDelete
  3. 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
    SQL Server DBA Training in Bangalore

    ReplyDelete
  4. This Was An Amazing ! I Haven't Seen This Type of Blog Ever
    call girls in dehradun

    ReplyDelete
  5. This Was An Amazing ! I Haven't Seen This Type of Blog Ever
    call girls in ghaziabad

    ReplyDelete
  6. This Was An Amazing ! I Haven't Seen This Type of Blog Ever
    call girls in gurgaon

    ReplyDelete