When last I worked with C++, it was while working on my master’s thesis ten
years ago, using a basic text editor in a Red Hat Linux 5.0 installation. A new
task in front of me: replace a Reporting Services report, which was exporting to
CSV, with a new solution that will allow me to create multiple files, with max
150,000 records each. The first challenge is speed: with that many records, only
bulk copy will be reasonable. The second is splitting the file. I thought about
calling BCP from a C# process, because unfortunately managed code only offers
bulk loading into a SQL Server database, not from database to file. But C++
is another story, thanks to the Bulk Copy Driver
Extensions made available by Microsoft. So, time for a C# developer to brush
up on C++, and learn it the Visual Studio way!