merge 2 columns to one?!

Hello everybody!
I′m trying to put together two columns of integer into one. They are coming from the same source table, so the "merge"-Task doesn′t work. This is what they look like:
column1: <123>
column2: <0123456>
The result should be:
merged_column: <1230123456>
Is there a task for that kind of operation or do I have to write a script? I would like do do that within the data flow.

thanks in advance! you can use SQL to concatenate these columns

select
column1
, column2
, cast(column1 as nvarchar) + cast(column2 as nvarchar) as column3
from
yourtable

how you use this depends on what you are trying to do|||

So basically you want to concatenate 2 integer columns right? You can try with the derivate column transform for that. Notice that you might need to cast them as string before concatenating them

Rafael Salas

|||Thats quite simple - I just forgot that this is possible in SQL :D
Thanks for your help!sql