Microsoft SQL Server¶
To be able to use the Microsoft SQL Server API to perform bulk data loads, first you need to follow these steps:
Install the Microsoft Command Line Utilities for SQL Server on the host where the Virtual DataPort server runs:
Edit the JDBC data source and click the tab Read & Write. Then, select Use bulk data load APIs and in the Bcp executable location box, enter the path to the file
Windows: it usually is in
c:\Program Files\Microsoft SQL Server. For example,
c:\Program Files\Microsoft SQL Server\bcp.exe.
Linux: it usually is in
/opt/mssql-tools/bin. For example,
The process is the same regardless of if you selected a jTDS adapter or a Microsoft adapter.