"Jim Heavey" <JimHeavey@discussions.microsoft.com> wrote in message
news:JimHeavey@discussions.microsoft.com:
> I have an Oracle table which has about 30 millions rows on it. I have a
> SQL
> table which has about 20 thousand rows on it. I want to pull from the
> Oracle
> table the corresponding rows from the SQL table. Would I use DTS for
> this?
> Is there a way for me to join the information from these two tables or an
> I
> forced to bring down all 30 million rows from the oracle table and then
> load
> them into a SQL table and then do my join at that time? Sounds like a
> awful
> lot of processing. ANy ideas of how this might be structured?