In order to Update/Delete records you must specify update key.
(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=?
For more technologies supported by our ETL Software see Advanced ETL Processor Versions