"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:uE1n08asGHA.4264@TK2MSFTNGP04.phx.gbl...
> 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_@uncw.edu> wrote in message
> news:eyoC66asGHA.3832@TK2MSFTNGP06.phx.gbl...
>> 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.
>>
>>
>>
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:%23pgmxWbsGHA.904@TK2MSFTNGP03.phx.gbl...
> 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_@uncw.edu> wrote in message
> news:%23EZhADbsGHA.1224@TK2MSFTNGP03.phx.gbl...
>> 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@no-spam.sqldts.com> wrote in message
>> news:uE1n08asGHA.4264@TK2MSFTNGP04.phx.gbl...
>>> 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_@uncw.edu> wrote in message
>>> news:eyoC66asGHA.3832@TK2MSFTNGP06.phx.gbl...
>>>> 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.
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

"dw" <cougarmana_NOSPAM_@uncw.edu> wrote in message
news:eyoC66asGHA.3832@TK2MSFTNGP06.phx.gbl...
> 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.
>
>
>

"dw" <cougarmana_NOSPAM_@uncw.edu> wrote in message
news:%23EZhADbsGHA.1224@TK2MSFTNGP03.phx.gbl...
> 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@no-spam.sqldts.com> wrote in message
> news:uE1n08asGHA.4264@TK2MSFTNGP04.phx.gbl...
>> 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_@uncw.edu> wrote in message
>> news:eyoC66asGHA.3832@TK2MSFTNGP06.phx.gbl...
>>> 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.
>>>
>>>
>>>
>>
>>
>
>