Updating or Deleting Records

In order to Update/Delete, records user must specify an update key.

For the example provided below, Visual Importer ETL will execute the following SQL
(Update key is CustomerId, OrderNo)

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

If no records found Visual Importer ETL will add new records

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

If any records found Visual Importer ETL will update them by executing

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

If no records found Visual Importer ETL will add new records

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

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

It is also possible to manually edit Insert/Update/Delete/Count SQL Statements. 
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

  • aetle/import/updating_deleting_records.txt
  • Last modified: 15/05/2018 10:49
  • by admin