SqlBulkCopy Tutorial - Knowledge Base (KB)

Parallel Bulk Inserting with SqlBulkCopy and Azure

I have an azure app on the cloud with a sql azure database. I have a worker role which needs to do parsing+processing on a file (up to ~30 million rows) so i can't directly use BCP or SSIS....I'm currently using SqlBulkCopy, however this seems too slow a...

How use GNU parallel and GNU SQL with \copy in PostgreSQL

I want to do a bulk load to a PostgreSQL database, there are several files and are pretty big. I just read in ...Using GNU Parallel With split... about the ...GNU Parallel... and ...GNU SQL..., and It looks fantastic, Could some one help me with an exampl...

indexoutofrangeexception in Datatable with Parallel.Foreach

I am trying to augment a DataTable that has IP addresses in one column with their reverse dns mapping. I am getting this DataTable from somewhere else. I am then exporting this table to SQL Server using SQLBulkcopy...I am adding two columns, one for the d...

Importing Data in Parallel in SQL Server

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...