I have more than 100 files to import into the sql server and most of them are of 500 MB. I want to leverage the the parallel import utility of SQL server and have read a number of webpages, like the following ones:
How to load 1 TB data in 30 minutes
Importing Data in Parallel with Table Level Locking
and the answers in stackoverflow
Fastest way to insert in parallel to a single table
However, none of them have given a simple example with code. I know how to use bulk insert/bcp, but I don't know where to start with parallel import? Can anyone help me with it?
My system is Windows and I'm using SQL server 2016. The source data file is in txt format.
Thanks in advance for your help!