Can I use case condition in SSIS

Question

I can use case when in tsql, is it possible to use case condition in SSIS?

Answer 1

Hi @sql test,

Do you mean like this?

Field == "TrueCondition1" ? “True” : ( Field == "TrueCondition2" ? “True” : ( Field == "TrueCondition3 " ? “True” : ( Field == "TrueCondition4" ? “True” : “False"  ) ) )

A same thread you may take a reference to witing-a-case-statement-in-ssis.

If I misunderstand your issue, you may provide some sample data and your expected result for us to do more test.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

I can use case when in tsql, is it possible to use case condition in SSIS?

Sure you can.

But where do you want to; you didn't provided and deatlied information about where and how?