Home Forums Data Warehousing Integration Services Derived Column Error RE: Derived Column Error

  • August 29, 2012 at 10:17 pm

    #1531710

    Hi

    try like below

    (civilianYears == "--" || TRIM(civilianYears) == "" || ISNULL (civilianYears)) ? NULL(DT_I4) : (DT_I4)civilianYears