Microsoft SQL Server bcp

This section lists the configuration file parameters that affect cloning with bcp, as well as the files that are created when you use bcp.

Note: You must select the Select Into/Bulk Copy option. Failure to select this option may result in a corrupt log device.

The following client configuration file parameters affect the bcp utility. For more details, see [Bulk_Loader].

Parameter	Description
bcp_batch_size	The bcp utility can load a table in several batches instead of loading the entire table in a single operation. You can control the bcp utility batch size using this parameter.
bcp_code_page	Adds the -C code_page to the bcp command line. For example, because the Japanese code page is 932, setting this parameter to 932 adds -C 932 to the bcp command line.
bcp_packet_size	Defines the network packet size value for the bcp utility (applies to remote servers only). If you have wide tables, setting this parameter to a packet size larger than the default (4096) can speed up loading the data into the table at the expense of system resources.
bcp_copied_msg	Enables the bcp_auditor program to determine whether or not a bcp was successful in cases where the database language is not English.
bcp_delim	Defines the delimiter character bcp uses (the TAB character, by default). If you want to preserve TAB characters in your data, set this parameter to a value that allows multiple characters.
max_errors	Controls the bulk loader’s tolerance to records that are discarded due to data errors.
max_temp_storage	Activates the segmented bulk load feature, which allows you to specify the maximum amount of storage that dbutility should use for temporary files.
use_char_mode_bcp	This parameter works in the following ways: Causes the bcp to assume that all data fields are type CHAR when the data is being loaded into the relational database Forces the bcp to use the tab character as the bcp delimiter.