Honestly, if any data transformation is required, it should be in Derived Columns, trust me on this, people have spends a lot of hours to diagnose the issue, if these kind of logic is written inside hidden in the flows, just like you are doing right now. as per your logic, all the relative data is coming in the data flow.

so i will go to my previous comments i-e

Create a Derive Column data flow, place all the logic in the expression by doing so you will get the updated column you wanted, just use that column in the oledb command.

Simple, readable and scalable.

Make sense?