Post reply

Error on conditional operator in derived column task

  • 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

  • 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.

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

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