SqlBulkCopy Tutorial - Knowledge Base (KB)

java.lang.NoSuchMethodError: com.microsoft.sqlserver.jdbc.SQLServerBulkCopyOptions.setAllowEncryptedValueModifications(Z)V

I am trying to utilize the bulkCopyToSqlDB function for the microsoft sql server jdbc driver with the sql spark connector found ...here.... ...This is the syntax to launch the spark shell:...spark-shell --jars /developer/sqljdbc_6.4/enu/mssql-jdbc-6.4.0.j...

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