Fastest way to load data into sql server

load_csv_to_sql_server.sql

--- Load from table dump_1.csv to dump_100.csv 
--- *.csv has million records

DECLARE @i int = 0
DECLARE @fromTable VARCHAR(MAX)
declare @sql varchar(max)

WHILE @i < 100
BEGIN
    print @i
    set @fromTable = '''D:\mariadb\data\final\dump_'+ cast(@i as varchar(3)) +'.csv''' 
	set @sql = 'BULK INSERT tblevent
				FROM ' + @fromTable + '
				WITH
				(
					FIRSTROW = 1, FIELDTERMINATOR = '';'', ROWTERMINATOR = ''0x0a'',ERRORFILE = ''D:\mariadb\data\final\err.csv'',TABLOCK
				)'
	SET @i = @i + 1
	exec(@sql)
END