CAST DT_WSTR into DT_I8 (String to INT)


  • I have a variable @stringvar which is DT_WSTR and is set to -1

    I need to set a Column in data flow Col1 which is INT to this variable @stringVar.

    in order to do this, In dervice colmn transformation I just Replace the Col1 with expression: ISNULL(Col1) ? (DT_I8)@[ConstantsMeta::strinVar] : Col1

    however, this fails with an error unable to cast to INT.

    Please advice



    BR, AWM
    Thursday, September 15, 2011 6:44 PM

All replies