Can I load only specific rows of data?

Is there a way to load only specific rows of data into a table in a SSIS package?

I am copying data from 2 separate ingres databases tables that have the same table structure into one SQLServer table using the ADO.NET DataReader Source for ODBC.

Let's say table1 from db1 and table2 from db2 for example.

table1 in db1 contains two rows:

MemberID - 1
Name - Rob

MemberID - 2
Name - James

table2 in db2 contains one row:

MemberID - 1
Name - Rob
MemberID - 2
Name - JAMES

I would like my SSIS job to load all data from table1 in db1 and then only load the data from table2 in db2 where the data in the row is different (as in 'JAMES').

Is there a data flow transformation that can help me do this?

I previously did this in 2000 DTS but had to load the data into 2 separate 'holding' tables and use T-SQL to update the table1 in db1 and was hoping I cuold cut out these steps in SSIS.

I was hoping that SSIS might have some new quick way to do this (lookups maybe?)

Can you help? Thank You

You can use the Lookup transform or the Merge Join transform. T-SQL is still a valid option if it works best for you.

Jamie did a nice comparison here-

Get all from Table A that isn't in Table B
(http://www.sqlis.com/default.aspx?311)|||Thank you

I shall have a read of the article and give it a try