Bulk insert command - data_link_for_geox - Latest

BULK INSERT [ database_name]. [ schema_name ] . [ table_name ] FROM 'path\data_file' WITH
(FORMATFILE = 'path\*.fmt', FIRSTROW = 2, BATCHSIZE = 1000000, ROWS_PER_BATCH = 500000, 
    ERRORFILE = 'path\abc.log', MAXERRORS = 5000000 )

Example:

BULK INSERT 
datalink.dbo.data_link_geox FROM 'C:\nationwide\geox_precisely_data\' WITH 
FORMATFILE = ' C:\nationwide\geox_precisely_data\data_link_for_geox_usa.fmt', FIRSTROW = 2,BATCHSIZE = 1000000, 
ROWS_PER_BATCH = 500000,ERRORFILE = ' C:\nationwide\geox_precisely_data\abc.log', MAXERRORS = 5000000)