i want a function like ifNull function to use in expression builder

Hi,

I wonder if there a function that i can use in the expression builder that return a value (e.g o) if the input value is null ( Like ifnull(colum1,0) )

i hope to have the answer because i need it so much.

Maylo

dont know if understood very well...

but....

You can use the function IIF(condition, TRUE, FALSE)

And can use IsEmpty function...

explain better!

Regards!

|||

Maylo wrote:

Hi,

I wonder if there a function that i can use in the expression builder that return a value (e.g o) if the input value is null ( Like ifnull(colum1,0) )

i hope to have the answer because i need it so much.

Maylo

Have you even opened up the expression builder in SSIS? Have you looked at the list of available functions on the right-hand side? Specifically the "NULL Functions" folder?

To answer your question, use: ISNULL(expression)

|||

i try IIF(condition, TRUE, FALSE) and it said that IIF is not recognized ,

let me more clear in explaination

iam using Conditional Split Component and i want to be in its condition some like that Condition

( ( case ColumnX is null then zero else then ColumnX ) ==ColumnY )

then underline part is what i want to translate to a right experision to be used in the Conditional Split Component cases.

i hope you can help me soon

Best wishes

Maylo

|||

Maylo wrote:

i try IIF(condition, TRUE, FALSE) and it said that IIF is not recognized ,

let me more clear in explaination

iam using Conditional Split Component and i want to be in its condition some like that Condition

( ( case ColumnX is null then zero else then ColumnX ) ==ColumnY )

then underline part is what i want to translate to a right experision to be used in the Conditional Split Component cases.

i hope you can help me soon

Best wishes

Maylo

Yeah, Pedro wasn't on the right page for SSIS expressions.

This is what you want:

ISNULL([ColumnX]) ? 0 : [ColumnX]|||

Yeah you are right, I was thinking in SSAS...

Sorry... I was sleeping! :-)

Regards!

||| , ok any one know it in the SSIS