I'm pretty new to SSIS, and I'd like to be pointed in the right direction to
achieve a problem I've hit a brick wall with. I would like to concatenate a
set of strings, but not across columns, but down a row - a String-Aggregation
like function - and create a new column with the output.

e.g
MyDataSet looks like
trip_number flight_from flight_to itinerary
1 'London' 'New York' ''
1 'New York' 'WashingtonDC' ''
2 'London' 'Zurich' ''

And I want to derive the following
1 'London' 'New York' 'London-New York / New York-Washington'
1 'New York' 'Washington' 'London-New York / New
York-Washington'
2 'London' 'Zurich' 'London-Zurich'

What would be the best way to achieve this?

Thanks in advance

What might work for you is is you have the same data on two inputs coming
into a merge join transform. You join on key columns.

If after that you need to do anything else you could use a derived column
transform.

Allan


"Jim" <Jim (AT) discussions (DOT) microsoft.com> wrote

Thanks Allan,

Can you explain exactly how it would work.

I think the join (trip_numer to trip_number in this case) will cartesian and
create a 5 records dataset. How would I then concatenate the
flight_from/flight_to columns and populate the itinerary field?

Cheers,

Jim
"Allan Mitchell" wrote: