Bulk delete contacts using IDs from SQL Server

Deletes multiple contacts by ID. IDs are read from a SQL Server SELECT statement or stored procedure. The result set must include an Id column (e.g. from a staging table such as StagingContacts) with the contact IDs to delete.

DELETE FROM Contacts
SOURCE (
  'MSSQL',
  'Data Source=localhost;Initial Catalog=Test;Integrated Security=true',
  'SELECT Id FROM StagingContacts'
)