.net - ssis Derive update -

I am trying to merge data together on a primary key, which will be identical in two record sets.

I have a primary key set with 5 column data and then I have a second record set with the primary key and 5 new colums, I am able to merge both record sets together I want to be there, so I can see a primary key and 10 columns which are not applicable to any data, it is just empty.

Anyone can help please :)

< P> Have you told about the guidance of MSDN? It is a little flakey with detail, but it should help to point you in the right direction.

The most annoying part is that data should be sorted before being merged.

There is a more detailed guide on how to get merge in MSSQL tips.

Good luck, hope you are working on it.