SQL Server

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

The process is the same regardless of the adapter selected: JTDS or the Microsoft driver.