When migrating large volumes of data from SQL Server to Salesforce, we use the Data Loader tool. But there's a warning in the terminal that holds up the loading process when the source data contains nulls:

[java] 2017-05-18 17:50:56,959 WARN
[execute] visitor.BulkLoadVisitor writeSingleColumn (BulkLoadVisitor.java:222)
- No value provided for field: RecordTypeId
- No value provided for field: RecordTypeId
- No value provided for field: RecordTypeId ...

This gets streamed to the terminal for each NULL field of each record, delaying the creation of the next Bulk API Batch. The nag is output from Line 222 of BulkVisitorLoader.java and has no configuration to disable it.

// all null values should be ignored when using bulk API
getLogger().warn(Messages.getMessage(getClass(), "noFieldVal", fieldName));

This is reported elsewhere too:

Solution

Here's a compiled version without the nag which you can download: dataloader-59.0.0-uber.jar (21.8MB) - longer term, there's also a request on GitHub to quieten the nag using a process.enableNoFieldValWarning configuration parameter.