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:
Download the Microsoft Command Line Utilities for SQL Server.
Choose the x64 version because it is targeted at hosts that run 64-bit operating system.
Install this package.
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
bcp(it usually is in
c:\Program Files\Microsoft SQL Server). For example,
c:\Program Files\Microsoft SQL Server\bcp.exe.
The process is the same regardless of if you selected a jTDS adapter or a Microsoft adapter.