Error on conditional operator in derived column task

• reach.tharan

  SSC Rookie

  Points: 26

  More actions

  February 24, 2012 at 8:33 am

  #253512

  I am creating a dervied column with expression as

  len(diag)>3?stuff(diag,4,0,'.'):diag

  diag=columnname

  can any one tell me what is the error in that since i am getting error as

  "Parsing expression failed" single quation the line 1 is not expect

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  February 24, 2012 at 11:38 am

  #1451531

  The SSIS expression builder is not SQL, so first off I don't think Stuff will work. If it does, you need double " quotes not single ' quotes in your last argument.