skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The SQL Server Wire Protocol Driver : Connection Option Descriptions : Bulk Character Threshold
  
Bulk Character Threshold
Attribute
BulkCharacterThreshold (BCT)
Purpose
The maximum size, in KB, of character data that is exported to the bulk data file.
Valid Values
-1 | 0 | x
where:
x
is an integer that specifies the number of KB.
Behavior
If set to -1, all character data, regardless of size, is written to the bulk data file, not to an external file.
If set to 0, all character data regardless of size, is written to an external file, not the bulk data file. A reference to the external file is written to the bulk data file.
If set to x, any character data exceeding this specified number of KB is written to an external file, not the bulk data file. A reference to the external file is written to the bulk data file.
Default
-1
GUI Tab
Bulk tab