Post reply

How write if condition in the derived with appending string

  • October 13, 2015 at 8:50 am

    #308796

    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

  • October 13, 2015 at 9:39 am

    #1833025

    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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply