I'm not sure I quite follow exactly what it is you need to do, but the derived column transformation allows you to change column values (or add in new columns) based on various criteria. This could be the thing you are looking for.
Tom
Life: it twists and turns like a twisty turny thing