Error in precedence Constraint Expression

• baseehkhan

  Mr or Mrs. 500

  Points: 535

  More actions

  October 3, 2012 at 12:41 am

  #393294

  Hi,

  Am new to ssis i given the below condition in constraint expression it show error help any body

  convert(date,getdate(),111)=convert(date,dateadd(dd,-1,DATEADD(wk,DATEDIFF(wk,0,dateadd(dd,7-datepart(day,DATEADD(qq, DATEDIFF(qq,0,getdate()), 0)),DATEADD(qq, DATEDIFF(qq,0,getdate()), 0))), 0)),111)

  Error is:

  Error at Constraint 5: The expression contains unrecognized token "date". If "date" is a variable, it should be expressed as "@date". The specified token is not valid. If the token is intended to be a variable name, it should be prefixed with the @ symbol.

  Error at Constraint 5: Attempt to parse the expression "convert(date,getdate(),111)=convert(date,dateadd(dd,-1,DATEADD(wk,DATEDIFF(wk,0,dateadd(dd,7-datepart(day,DATEADD(qq, DATEDIFF(qq,0,getdate()), 0)),DATEADD(qq, DATEDIFF(qq,0,getdate()), 0))), 0)),111)" failed and returned error code 0xC00470A4. The expression cannot be parsed. It might contain invalid elements or it might not be well-formed. There may also be an out-of-memory error.

• venus.pvr

  SSCarpal Tunnel

  Points: 4813

  More actions

  October 4, 2012 at 2:56 pm

  #1545821

  I see a couple of issues here. variable User::date has to be used in expression as @date. there is no convert function at all.

  I am not sure as to what are you trying to evaluate. Might be more helpful if you gave more information.

  -Praveena