Home Forums SQL Server 2008 SQL Server 2008 - General SSIS derived column transformation failing on converting Blank rows from excel while converting the column from string to int RE: SSIS derived column transformation failing on converting Blank rows from excel while converting the column from string to int

  • July 30, 2015 at 8:52 am

    #1816166

    Mohamed I. (7/30/2015)

    ok

    did you try the expression with "?"

    FieldValue == "" ? (DT_I4) 0 : (DT_I4) FieldValue

    And with this :

    (ISNULL(FieldValue) OR (DT_WSTR,50) (TRIM(FieldValue))) == "" ? (DT_I4) 0 : (DT_I4) TRIM(FieldValue)

    :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t: