DT_Decimal Data Type Cutting off Decimal
37,223
Well it was pointed out that I needed to add the Scale that was missing.
Or even better do as this suggests and switch to numeric where I can set precision and scale.
Comments
-
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 beDT_Decimal
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.
Any idea why this is happening? For reference I'm going to a
Decimal(12,2)
SQL Server 2012 Database.