DT_Decimal Data Type Cutting off Decimal

37,223

Well it was pointed out that I needed to add the Scale that was missing.

Decimal

Or even better do as this suggests and switch to numeric where I can set precision and scale.

Numeric

Share:
37,223
Zane
Author by

Zane

DBA

Updated on November 08, 2020

Comments

  • Zane
    Zane over 3 years

    I have a flat file source that grabs a decimal value for the column Note Amount. The Source system specifies that this is a DECIMAL(12,2) file. I have the column in SSIS set to be DT_Decimal

    File

    The particular Flat file has a value of 122735.13 for one of it's amounts. However if I place a data viewer on the flow after the source it seems to be cutting the decimal off.

    DataFlow

    ResultsCut

    Any idea why this is happening? For reference I'm going to a Decimal(12,2) SQL Server 2012 Database.