Hi. Here's what I need to do in a DTS package and don't know how: Insert all
the values from an Oracle view into a SQL Server 2000 table where the value
from the source doesn't exist in one of the columns of the destination
table. Thanks.

Two Source adapters, one SQL Server and one Oracle. Use a Merge Join with a
LEFT OUTER JOIN to determine the rows that are in one set and not the other.

--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



"dw" <cougarmana_NOSPAM_ (AT) uncw (DOT) edu> wrote

Thanks, Mitchell. I've got the source adapters in my SQL Server 2000
package. Where do I declare the LEFT OUTER JOIN? On the data pump?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

It is in the Merge Join Component itself in a little dropdown at the top

BTW you will need sorted inputs to this component (HINT: Do this on the
Source Adapeter and flag the outputs as sorted)

--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



"dw" <cougarmana_NOSPAM_ (AT) uncw (DOT) edu> wrote

I think you're referring to SQL 2005 and not 2000. The version I'm using is
SQL 2000 and it doesn't have any such component "Merge Join". I'll have to
figure some other solution.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote