Matching Values In SSIS

Hi,

I have a table of parts which has a Tag column. The table is such that two parts can share a tag (but no more than two parts), essentially pairing them. I would like to use SSIS to match the parts based on this column value, so that I can add these into a new table.

For example, I could have:

(part1, tag-123, "a random part", serial123) and
(part2, tag-123, "another random part", serialxyz)

in the table, and would then concatenate the pair to enter into a new table, such that I have:

(part1, tag-123, "a random part", serial123, part2, tag-123, "another random part", serialxyz)

I'm new to SSIS and am unsure how I could achieve this, so if anyone could show me how I would appreciate it.

Thanks,

Simon