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=?
It is also possible to manually edit Insert/Update/Delete/Count SQL.
Tick user defined SQL than edit every SQL statement individually.
To regenerate the SQL statements clear it and open it again.

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

Confused? Ask question on our ETL Forum

  • aetl/processing_data/writer/updatedelete_records.txt
  • Last modified: 24/06/2015 16:57
  • by admin