I am trying to map the documenttype to documentno in the source table if the type is "CREDIT".

I don't know which functionality in SSIS I can use to do this type of transformation. Do I have to use a lookup?