Over the last 10 years or so I’ve been responsible for the import of many hundreds of millions of records into production SQL Server databases. The fastest and most reliable way I found to achieve this is using the ODBC Bulk Copy API. But it’s not the easiest thing to do in C#. In fact, C# code for this purpose is surprisingly rare.
Wanting a complete tool that I could easily share with clients and colleagues, I decided to create SqlBulkCopy. It is very fast and comprehensively tested. Special thanks to Jolin Qiao, SQL Server Professional Support Engineer at Microsoft, who got me answers for some pretty tough questions.