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

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 (AT) gmail (DOT) com" wrote:

Thank you Charles, good idea! I didnt try yet but I'm sure that this is
the way.

Thank again


Charles Kangai escreveu: