Please help

AMedina · Post by **AMedina** » Sun Jul 15, 2007 5:48 pm

My variable is not working.
parameter coming in pErrorFlag = Y
variable: If '#pErrorFlag#' = 'Y' then 1 else 0
Constraint: vError = 1 abort 1 row

ArndW · Post by **ArndW** » Sun Jul 15, 2007 5:51 pm

Remove the single quotes from around the variable, i.e.

Code: Select all

If #pErrorFlag# = 'Y' then 1 else 0

p.s. Welcome to DSXChange, but please use more meaningful subject lines in the future.

chulett · Post by **chulett** » Sun Jul 15, 2007 9:33 pm

And you don't need to explicitly set the 1 or 0, the expression will evaluate to that automagically:

Code: Select all

#pErrorFlag# = 'Y'

Is all you need.

DSguru2B · Post by **DSguru2B** » Mon Jul 16, 2007 6:58 pm

ANother point, if "pErrorFlag" is a job parameter then you dont even need to surround it with hashes within a transformer. Just use is as is. So no quotes and no hashes.