Post reply

Need Help with SSIS Expression

  • October 24, 2011 at 12:41 pm

    #245794

    I need help with an expression, I will try my best to explain what I have currently and what I need added. The possible values that could be in my variable (@var) are (4 is the newest value):

    1

    2

    3

    4

    My Current Expression is:

    @var =="1" ? "A1" : (@var == "2" ? "B2" : "C3")

    I also need to account for D4 in this expression. I have been trying (unsuccessfully) different things and nothing is working out for me.

    Any and all help will be greatly appreciated.

  • October 24, 2011 at 12:56 pm

    #1398857

    I got it figured out, in case anyone has the same issue, this is what I did:

    @var =="1" ? "A1" : (@var == "2" ? "B2" : @var == "3" ? "C3" : "D4")

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

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