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:

  1. 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.

  2. Install this package.

  3. 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.