Dilsa,
It looks like this is a fairly simple mapping, with only the first value requiring any manipulation before going to the destination. I would use a Derived Column task to send the new value you call "DATA" to the destination. You don't need to script this kind of task in SSIS.
hth
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices