Re: Update / Insert Table throught DTS

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 08:03:31 +0100

Can you not identify at the source changed rows?

If you can't then you could create an Oracle linked server from your SQL
Server and then issue your TSQL statements just like you were using another
SQL Server.

The problem with bringing over the rows into a table at the destination and
then performing the TSQL is that if the Oracle table is large then this may
take a while. 

-- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"AW" <odgam@asl.com.hk> wrote in message
news:eyb4l2GcEHA.716@TK2MSFTNGP11.phx.gbl...
> Dear all,
> I understand this has been asked before but I don't quite understand
exactly
> how to do this
>
> The situation is
> I have source data in Oracle database and the destination in MS Sql server
>
> Suppose I have table A in both Oracle database and MS Sql server which
have
> the same table stucture.
>
> Destination MS Sql server already have some rows
> Source Oracle server has the same rows (same Primary key) but updated
> columns and
>       rows that not exists in MS Sql server
>
> What I want to do  is using DTS to update the table if same PK is found in
> Destination table A, else insert the row in Table A of Destination?
>
> I have never use DTS before so I would like to ask all detailed steps that
I
> need to take in order to accomplish the above.
>
> The other thing is I don't want to create temp tables in the destination
> database to store all data and then run a store procedure to do the data
> transfer.  That will be my last option.
>
> Thanks  a lot.
>
>
>
>
>

Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: ODBC to Oracle 64bit missing rows
    ... the set of Oracle queries that I'm running ... through the linked server right now haven't given me that error.... ... I'm trucking on with 64-bit & Oracle's OLE DB drivers. ... I am on SQL Server 2005, ...
    (microsoft.public.sqlserver.connect)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem with SQL 2005 Integration Services Package
    ... I also encountered the problem - until I changed my destination data ... I WAS using a SQL Server Destination ... > package in debug mode on the server it runs sucessfully. ...
    (microsoft.public.sqlserver.dts)
Loading