Bulk Insert Command - community_link_-_colleges - community_link_-_metros - community_link_-_neighborhoods - community_link_-_residential - community_link_-_schools - market_link_-_5_digit_zip_codes - market_link_-_carrier_routes - market_link_-_census - market_link_-_congressional_districts - market_link_-_dmas - market_link_-_time_zones - master_link - 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

Example:

BULK INSERT
census.dbo
FROM 'C:\Census\Census_Data\Census'
WITH (FORMATFILE = 'C:\Census\census.FMT',
FIRSTROW = 1,
BATCHSIZE = 1000000
ROWS_PER_BATCH = 5000000
ERROFILE = 'C:\Census\abc.log',
MAXERRORS = 5000000