Before using the SQL Server API to perform bulk data loads, install
the SQL Server client
bcp on the host where the Virtual DataPort
server runs. Download it from https://www.microsoft.com/en-us/download/details.aspx?id=36433.
After this, when enabling “Use bulk data load API” on the “Read & Write”
tab of the data source, enter the path
bcp in the Bcp executable
The process is the same regardless of the adapter selected: JTDS or the Microsoft driver.