> Quicker to use SQL, and you say you already know how to do this. You can
> still use SQL against Oracle and SQL Server simultaneously by using linked
> servers. You can even perform a join query between a SQL Server table and an
> Oracle table. Look up "linked servers" in Books Online.
>
> e.g.
> INSERT INTO OracleServer.OracleDB.Emp.Scott
> SELECT * FROM MySQLServerTable WHERE ID NOT IN (SELECT EmpID FROM
> OracleServer.OracleDB.Emp.Scott)
>
> Hope this helps.
>
> Charles Kangai, MCT, MCDBA
> Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
> Services" http://www.learningtree.com/courses/134.htm
> Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
> http://www.learningtree.com/courses/523.htm
> email alias: charles
> email domain: kangai.demon.co.uk
>
>
>
>
> "biano.brito@gmail.com" wrote:
>
> > I need to update a table in the oracle with data that came from the SQL
> > Server but I cant delete all the lines in the oracle I need to check if
> > the line doenst exist in the destination table and then append this
> > line.
> >
> > I know how to do it using transact-sql when the source table and the
> > destination table is in the same place but how to do it when source is
> > SQL Server and the destionation is Oracle.
> >
> > Which object have I to use? Data Transformation Task? Data Driven Query
> > Task.
> >
> > Please help me!
> >
> > Thanks,
> > Fabiano
> >
> >