SQL Server批量插入超过100万行——需要性能改进

I have been tasked with developing a method for importing text files with 1 million or more rows into a table. Each row within the table is 856 Bytes, split into approximately 150 "columns" of data. I am using SQL Server 2012 Standard Edition. The activity related to the INSERTs is the only activity on the database. I have built a stored procedure that does the following:I have been tasked with developing a method for