Use a Derived Column transformation in your Data Flow before your Destination Node.P.s. Your sentence is a a bit conflicting; "prefix MO at end of the Data". A prefix is at the start of the data (as you showed), not the end.
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does :-P
Please always remember to encapsulate your code in IFCode Markup. For example [code=sql] [/code]
to read Jeffs Guide on how to post SQL questions, and get swift and helpful answers from the community