db_guy


Hi All,

I want to accomplish something like this , I want to sum two of my columns and pass them as input into a third column, looks pretty simple but I think the way ISNULL is handled in SSIS is different from the way it is handled in TSQL.

Basically I wanna write an expression for the following TSQL

(ISNULL(Column1 , 0) + ISNULL(Column2 ,0)) as Column3

Thanks




Re: ISNULL in SSIS

Jamie Thomson


Try:

( ISNULL( [Column1] ) 0 : [Column1] ) + ( ISNULL( [Column2] ) 0 : [Column2] )

-Jamie







Re: ISNULL in SSIS

db_guy

Wow, it parsed fine and I hope it works great too. Thanks for your input Jamie.

Thanks

Data_Guy