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