ODBC guide

Bulk delete customers using IDs from SQL Server

Bulk deletes customers by reading Id values from an external SQL Server database. You can also pass $$ContineOn404Error as a column to control error handling per row.

DELETE FROM Customers
SOURCE('MSSQL'
  ,'Data Source=localhost;Initial Catalog=tempdb;Integrated Security=true'
  ,'select 111 as Id,1 as [$$ContineOn404Error]
    UNION
    select 222 as Id,1 as [$$ContineOn404Error]
   '
)