Expression in Precedence Constraints

• UnionAll

  SSCrazy

  Points: 2102

  More actions

  November 14, 2011 at 1:50 pm

  #390855

  Hi,

  Is it possible to use a Like operator in the expression for precedence constraint?

  I am trying something similar to the following expression:

  @FileName Like "NewProducts*.txt"

  Based upon what the file name is, i need to execute different tasks.

  And the filenames have a date stamp appended to it. So i can't really use an "==" operator.

  Thanks.

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  November 14, 2011 at 2:05 pm

  #1407523

  Don't think so. But you can use a combination of SUBSTRING and RIGHT to achieve the same thing - something like this (untested):

  UPPER(SUBSTRING(@FileName,1,11))=="NEWPRODUCTS" && UPPER(RIGHT(@FileName,3))=="TXT"

  ---

• UnionAll

  SSCrazy

  Points: 2102

  More actions

  November 14, 2011 at 2:36 pm

  #1407542

  Thanks Phil!

  It worked.