Vikash,
I would like the expression to evaluate without quotes around zero:
[Obj Acct] == 0? Sub : (Sub == 0? [Obj Acct] : [Obj Acct] + "." + Sub)[/
so that it works the way my case statement works:
, AcctNum = CASE
When [Obj Acct] = 0 then [Sub]
When [Sub] = 0 then [Obj Acct]
Else [Obj Acct] + '.' + [Sub]
End
With quotes the expression parses in SSIS but column values are returning with periods even when there is no value in the Sub or [Obj Acct] columns. EG. 55515. or .111. To be honest, I don't know why 0 works, because those columns don't actually have a 0 in them. They are just blank.
However, without quotes the expression won't parse. Do you know what I can do?