How write if condition in the derived with appending string

• rajarajansudar

  SSC-Addicted

  Points: 470

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 246986

  More actions

  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.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel