Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Data Load

Author  Topic 

WoodHouse
Posting Yak Master

211 Posts

Posted - 2010-06-03 : 02:13:18
Hi

we have the ETL process like this

Fetch Data from source system which is in ORACLE

Inserts into Destination system which is SQL SERVER

I need to know how to create below process

1.Fetch Data from source system with ID column
2. Check the ID column to respective of rows in destination
if matches delete those records.
3. Then append the records to destination.

Help on this

Thanks


   

- Advertisement -