How To use 'And' operator in SSIS expression

#1

For my conditional split, I want to evaluate 2 input columns coming in as
follows:

ISNULL(column1) AND ISNULL(column2) -- this does not work
ISNULL(column1) + ISNULL(column2) -- this does not work
ISNULL(column1) & ISNULL(column2) -- this does not work

How do I do this?

tia
chris

#2

ISNULL(column1) && ISNULL(column2)
"Chris" <Chris (AT) discussions (DOT) microsoft.com>
For my conditional split, I want to evaluate 2 input columns coming in as
follows:

ISNULL(column1) AND ISNULL(column2) -- this does not work
ISNULL(column1) + ISNULL(column2) -- this does not work
ISNULL(column1) & ISNULL(column2) -- this does not work

How do I do this?

tia
chris

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How To use 'And' operator in SSIS expression

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How To use 'And' operator in SSIS expression - 07-17-2006 , 08:55 PM

Re: How To use 'And' operator in SSIS expression - 07-20-2006 , 09:15 AM