You can use BL_OPTIONS=
to pass options to the DBMS bulk-load facility when it is called,
thereby affecting how data is loaded and processed. You must separate
multiple options with commas and enclose the entire string of options
in quotation marks.
By default, no options
are specified. This option takes the same values as the
-h HINT
option of the Microsoft BCP utility. See the Microsoft SQL Server
documentation for more information about bulk copy options.
This option is valid
only when you use the Microsoft SQL Server driver or the Microsoft
SQL Server provider on Windows platforms.
ODBC: Supported
hints are ORDER, ROWS_PER_BATCH, KILOBYTES_PER_BATCH, TABLOCK, and
CHECK_CONSTRAINTS. If you specify UPDATE_LOCK_TYPE=TABLE, the TABLOCK
hint is automatically added.