How to Update/Delete Records

In order to Update/Delete records you must specify update key.

For the example provided below, Advanced ETL Processor will execute the following SQL (Update key is CustomerId, OrderNo).

Add New And Update Old Records

Select count(*) 
from [DEMO].[dbo].[orders] 
where CustomerId=? And OrderNo=?

If any records found Advanced ETL will update them by executing

Update [DEMO].[dbo].[orders]
set orderdate=?,
amount=?
where customerid=? And OrderNo=?

If no records found Advanced ETL will add new records

Update Records

Update [DEMO].[dbo].[orders]
set OrderDate=?,
Amount=?
where CustomerId=? And OrderNo=?

Delete Records

Delete from [DEMO].[dbo].[orders]
Where CustomerId=? And OrderNo=?