how to remove empty sting and null vale in conditional split ssis

Question

ssis and using vs2012, how to remove empty and null value in data flow?
2. how to trim all the input in data flow?

Answer 1

I have 3 record store in table with 2 column, ID and col1 as shown below.

ID col1
1 null
2 ''
3 'dd'

how to remove null and empty record in conditional splits in data flow task in ssis

my expected result is only retrieve the col1 with Val, for above case, it is the 3rd row where ID=3

Answer 2

Hi @nononame2021 ,

You can try the following expression in the SSIS Conditional Split Task:

ISNULL(col1) || TRIM(col1) == ""  

Answer 3

Hi @nononame2021 ,

I think YitzhakKhabinsky's reply could resolve your issue correctly.

You may click "Accept Answer" on the reply so that we could archive the case.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

I want to filter out the column named 'test' ="Y"
WHAT SHOULD I INPUT FOR OUTPUT NAME IN CONDITIONAL SPLIT?

I setup test=="Y"

it trigger error that requires a boolean result.
what should I setup in conditional splits so that select the test column = "Y"