Bulk create contacts using SQL Server data

Inserts multiple contacts by reading rows from a SQL Server database. Data is read from a SELECT statement (or stored procedure); column names or aliases must match the target contact properties (e.g. firstname, lastname, email). The driver uses the HubSpot bulk API to send the data.

INSERT INTO Contacts
SOURCE (
  'MSSQL',
  'Data Source=localhost;Initial Catalog=Test;Integrated Security=true',
  'SELECT firstname, lastname, email FROM StagingContacts'
)