SqlBulkCopy Tutorial - Knowledge Base (KB)

How to use the SQL Server JDBC bulk copy API

I run into some issues trying to map my column metadata with SQL Server Bulk Copy API and ...SQLServerBulkCSVFileRecord.... Just for test purposes I made a table consisting of only ...nvarchar(500)... columns and add the metadata like this:...fileRecord =...

Loading CSV data using SQLServerBulkCSVFileRecord with enclosing and nulls

I'm trying to load CSV data using the SQLServerBulkCSVFileRecord, however it seems that this doesn't allow for enclosed fields (stripping quotes) and supply a value for NULL. ...Any suggestions on how to get this working? Seems like such basic functionali...

Prevent growing transaction log with INSERT BULK with TABLOCK

I am working on writing a process which will write to SQL Server from Spark- Scala application. Its generating multiple INSERT BULK per partition of data (as expected), batchsize 100K records....As I am monitoring the transaction log, I can see its fillin...