Value In Field Bigger Than Data Type Precision SSIS RRS feed

  • Question

  • Hi,

    I have a field in derived columns (SSIS) that should present the unit net price in local currency.  
    The statement looks like this: 
    (DT_NUMERIC,15,6)(Currency == LocalCurrency_LB ? [DER Cast fields name].[Net price] : [DER Cast fields name].[Net price] / [Exchange rate])
    Datatype of the field is numeric (DT_Numeric) with a precision of 15 and a scale of 6
    it used to function well, but last night we had an issue with our source in which it was clear that a order had a net price that exceeded the max nr configured in the datatype (price looks like: 6.618.110.292.480.000). So, in this case I want to create an if statement saying that if the datatype does not match, put an ZERO as result and continue with the flow. 
    Any ideas?
    Thanks a lot...
    Tuesday, July 18, 2017 12:59 PM