Bulk Insert Command - Latest

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 = 5000000

BULK INSERT
distance_to_coast.dbo
FROM 'C:\Distance_to_Coast\Distance_to_Coast\Distance_to_Coast'
WITH (FORMATFILE = 'C:\Distance_to_Coast\dist_to_coast.FMT',
FIRSTROW = 1,
BATCHSIZE = 1000000,
ROWS PER BATCH = 5000000,
ERRORFILE = 'C:\Distance_to_Coast\abc.log',
MAXERRORS = 5000000