• 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