• rajarajansudar (10/13/2015)


    i need to write condtion like this

    if ( System ID =="RE2")

    {

    Account_num +"-"+ coulum

    }

    i wrote in SSIS like below

    System ID ? "RE2" : [Client ID] + "_" + System ID

    but give error can u help me

    My output should be : 1234-Re2

    The syntax is slightly different from that.

    Boolean Condition? do if true : do if false

    I cannot rewrite what you have written, because your System Id contains a space, which will fail anyway.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.