ssis expression

Question

I have the txt file with several columns (Code, Earing, OverTime, Vacation). I need to set the fit value for column Earning =10 if the the Code ="A" .

Something like this but I am not sure?

[Code] == "A" ? [Earning] ="10"

Thanks

Answer 1

Hi @Vicki ,

You may use below code:

Code == "A" ? "10" : [ Earing]  

or

Code == "A" ? "10" : ""  

Regards，

Zoe

---

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