Multiple Expressions in Precedence Constraints

Is it possible in a precedence constraint to have multiple expressions evaluated? IE

Operation set to Expression and expression to evaluate is: @File = x or @File = y

Thanks

June 20th, 2007 3:22pm

(@File == "x" || @File == "y")
Free Windows Admin Tool Kit Click here and download it now
June 20th, 2007 3:25pm

I am an idiot!

Thanks

June 20th, 2007 3:29pm

If this was correct for you, please mark this thread as answered.
Free Windows Admin Tool Kit Click here and download it now
June 20th, 2007 3:31pm

Hi

I found this page on Google and thought I will update it with a link to multiple expressions in SSIS 2012 video which also applies to 2005 and 2008. On the page you can go to SSIS Tutorial that covers more examples for precedence constraints.

Take care

Emil

December 17th, 2012 9:13am

what if you want to do something like @File1 = x AND @File2 = y, requiring both conditions to test as true?
Free Windows Admin Tool Kit Click here and download it now
April 17th, 2015 4:29pm

I think it's this  (&&  instead of ||)

(@File == "x" && @File == "y")

April 17th, 2015 5:09pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics