• The syntax for the derived column gets difficult to maintain doing it this way, as more lookups are added.

    An alternative is to use a lookup table - either physical or virtual (ie, generated at run time) - and add a suitable lookup to your data flow.

    The benefit of using a physical table is that you can add more lookups without having to modify the design of your package.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.