Importing Data in Parallel in SQL Server

bulkinsert bulk-load parallel-processing sqlbulkcopy sql-server

Question

I need to import more than 100 files, the most of which are 500 MB files, into the sql server. I want to use SQL Server's parallel import feature, therefore I've studied a lot of websites, including the ones below:

1 TB of data may be loaded in 30 minutes.

https://technet.microsoft.com/en-us/library/dd537533(v=sql.100).aspx

Parallel Data Import with Table Level Locking

https://technet.microsoft.com/en-us/library/ms186341(v=sql.105).aspx

For Bulk Import, controlling Locking Behavior

https://technet.microsoft.com/en-us/library/ms180876(v=sql.105).aspx

, as well as responses on stackoverflow

fastest method for simultaneous inserting into a single table

None of them, however, have provided a straightforward illustration using code. Although I am familiar with bulk insert/bcp, how do I begin with parallel import? Anyone who can assist me with it?

Windows powers my system, and I'm using SQL server 2016. Txt is the format of the source data file.

Thanks for your assistance in advance!

Jason

1
0
5/23/2017 12:33:32 PM

Accepted Answer

ZZZ_tmp
3
11/22/2016 6:03:53 PM


Related Questions





Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow