ssis - how to filter out some value

Question

my ssis is to import excel into sql server table, how can I filter out some value before importing into table using split conditions in data flow task

I try to add name = valid , value = ID !="LD" && ID!="AB"

after execution, it become only the id with LD and AB.

how to select the name in the split conditional arrow to filter out these ID?

Answer 1

Hi @nononame2021 ,

It is better to use the following expression in the SSIS Conditional Split Task.
It makes easy to add more conditions, and thus more maintainable.

FINDSTRING("_LD_AB_", "_" + yourColumnName + "_", 1) == 0  

Answer 2

how can I make different flow to import into different table by using the conditional in slipt conditional.

Answer 3

Hi @nononame2021 ,

As YitzhakKhabinsky mentioned, you may use findstring to filter out some value.

And please note that normally single case we focus on one issue.

To import into different table by using the conditional in split conditional, here is a detailed tutorials you may take a reference below.

ssis-conditional-split-transform-overview

You have post several issues on Q&A, if the resolution is helpful, please mark it as answer so other user with similar problem could see this easier.

This behavior could also encourage our experts to offer more help.

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.