help in inserting data

[sqlintegratonservice]

hi, i am new to sql server, .............

i have 2 databases,i have to insert data from the old database to new database........
for example i have first_name column in new database but i have first_name,first_name1,first_name2 ... 3 columns in old database...... i have to insert 3 columns into the 1 column in new database.......

i have done like this .......
1. In the dataflow
task i have taken oledb source in which i have selected 3 columns and sorted it...
2.on the side taken another oledb1 source which have 1 column first_name and sorted.....

what should i do to insert 3 colums in to the one column.........
please help me urgently...........

 

[MDXer]

use a derived column task and concatenate the 3 columns together.