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.