Simple question - compare Strings with SSIS expression language

• blasto_max

  SSCertifiable

  Points: 5025

  More actions

  December 27, 2013 at 12:55 pm

  #287759

  SSIS variables - strOne = YES, strTwo = YES. I want to compare strings using ssis expression language (ie inside a variable's expression box, constraint of task flow arrow etc).

  Will @strOne == @strTwo be true ? I hope its not like programming languages where you need to do @strOne.Equals(@strTwo) instead of ==. Also is @strOne == "YES" true ?

• Nevyn

  SSChampion

  Points: 14210

  More actions

  December 30, 2013 at 9:51 am

  #1676422

  Yes, you should be able to do == .

• aamir.nmhu

  SSC Enthusiast

  Points: 108

  More actions

  December 30, 2013 at 10:22 am

  #1676428

  you can compare the variables like this

  @String==@String2

  Thank you

  Aamir

  http://sqlage.blogspot.com/