> Hi,
>
> I'm using a Merge Join with two OLEDB data sources to output the
> matching
> records on a specific key to a table on the database.
> I also need to record the records that DON'T match to a second table.
> How
> can I do that?
> Thanks very much,
>
> Marcelo.
>

"Allan Mitchell" wrote:

> Hello JMMB,
>
> Your two inputs go into the MERGE JOIN transform.
>
> There is a box at the top of the designer window that asks you how to join
> the keys
>
> INNER, LEFT OUTER, FULL OUTER
>
> You want LEFT OUTER
>
> Let's say your key in the right hand side table is called MyKey. You return
> MyKey
>
> After the results pop out the bottom you dive into a conditional split
>
> Create a new output called "Never Seen Before" and the Expression will be
>
> ISNULL([MyKey])
>
>
> Make sense?
>
>
> --
>
> Allan Mitchell
> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
> http://www.konesans.com
>
> > Hi,
> >
> > I'm using a Merge Join with two OLEDB data sources to output the
> > matching
> > records on a specific key to a table on the database.
> > I also need to record the records that DON'T match to a second table.
> > How
> > can I do that?
> > Thanks very much,
> >
> > Marcelo.
> >
>
>