Tuesday, February 12, 2013

check for null and zero length in SSIS

I did it thus

ISNULL([Column 0]) ?  FALSE  : LEN([Column 0]) > 0

I did it this way not to avoid short circuit issues
also, of course len on a null is null

No comments:

Post a Comment