Populate MSSQL table with CSV

import_csv.sql

BEGIN TRANSACTION;

TRUNCATE TABLE MultiListingCampaignMappings;

BULK INSERT MultiListingCampaignMappings
    FROM 'c:\users\Administrator\multimappings.csv'
    WITH
    (
    FIELDTERMINATOR = ',',  --CSV field delimiter
    ROWTERMINATOR = '\n'    --Use to shift the control to next row
    );

COMMIT TRANSACTION;