ssis - Updating column name with source system where data comes from -

am new ssis , started learning sample projects.

am trying below task , not sure how start , didn't in google well.

example scenario:

i have created "student" table in db. student columns : id,name,class,section,source

and trying pull data table different data sources a,b,c

am trying insert data school table a,b,c sources

1 row : how updating **a** insert in id **a** insert in name **b** insert in class **c** insert section

and in source column of table need have format mentioning data-source each column comes id:a,name:a,class:b,section:c

sample o/p

id|name  | class|  section |  source 1 | test | test | test     | id:a,name:a,class:b,class:c 2 | test2| test | test     | id:a,name:a,class:b,class:c 

what did ?

i tried pulling data sources didn't find way update source section.

how implement scenario.. ?

thanks

i add columns each data flow source values e.g

data source = 'id:a,name:a' data source b = 'class:b' data source c = 'class:c' 

then concatenated them in derived column transformation, , deliver them through existing data flow destination.