BULK INSERT
<database_name>.<schema_name>.<table_name>
FROM 'path\data_file_name
WITH (FORMATFILE = '<path>\format_file_name>.FMT',
FIRSTROW = 1,
BATCHSIZE = 1000000,
ROWS_PER_BATCH = 5000000,
ERRORFILE = '<path>\log_file_name.log',
MAXERRORS = 5000000Example:
BULK INSERT
Insurance_Premium_Tax.dbo
FROM 'C:\Insurance_Premium_Tax\Insurance_Premium_Tax_Data\Insurance_Premium_Tax'
WITH (FORMATFILE = 'C:\Insurance_Premium_Tax\Insurance_Premium_Tax.FMT',
FIRSTROW = 1,
BATCHSIZE = 1000000
ROWS_PER_BATCH = 5000000
ERROFILE = 'C:\Insurance_Premium_Tax\abc.log',
MAXERRORS = 5000000