none
expression in Expression Builder RRS feed

  • Question

  • Hi I am new to SSIS, please advise how to put together the variables below in expression builder

    "

     @[User::t_info] != ""? @[User::t_info]:"Invalid email address"

    Email Notification Sent To:  "+ @[User::t_fuln] +"

    "

    Thanks

    Wednesday, November 29, 2017 3:28 PM

All replies

  • Hi Vicki,

    I like to test for string length

    so it'd look like

    len(@[User::t_info]) > 0 ? @[User::t_info]:"Invalid email address. Email Notification Sent To:" + @[User::t_fuln] 


    Arthur

    MyBlog


    Twitter

    Wednesday, November 29, 2017 4:07 PM
    Moderator
  • Expression builder of what? A variable, a precedence constraint, an expression task?

    What could be your error is that you have a quote after "address" which is closing off the string but shouldn't be (at a guess)

    Wednesday, November 29, 2017 6:54 PM
  • Thanks,  how can i make + @[User::t_fuln] + as the hyperlink?
    Wednesday, November 29, 2017 7:12 PM
  • You can make it a HTML hyperlink if you then make it part of a HTML formatted email.

    Arthur

    MyBlog


    Twitter

    Wednesday, November 29, 2017 7:30 PM
    Moderator