Left outer join

Hi All,

I have 2 servers and each server has a table. On table is in production and the one on the second server is updated daily.

What I am trying to do is create a left outer join where server s table primary key is null. That way I will have the rows from production taht need to go into the reporting table.

I created a package with 2 oledb datasources (one for each table). The output, from each goes into it;s own sort Sort Transformation Editor. From the sort(s) the data goes to a mergejoin.

I was under the impression that I could filter with a where 2.table.primary key is null.

What is the correct way to do this

TIA,

Roy