Update/Delete Records

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

Update Key

For the example provided below, Advanced ETL Processor will execute the following SQL

(Update key is CustomerId, OrderNo).

Add/Delete Transformation

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=?,
where customerid=? And OrderNo=?

If no records found Advanced ETL will add new records

Update Records

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

Delete Records

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

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum
Last updated: September 17, 2022