BCP (Bulk Copy Format) is Microsoft SQL Server’s technical data format that defines data structures to store different database data type values for import/export. The format fully defines the interpretation of each data column so that the set of values specified in the data file could be read. The BCP utility uses the BCP file format to read data from such a file and identify it.
BCP File Format
The BCP format file is an XML document that defines the column order, name and data type. It lets users import/export large amount data from data file specifying these fields. This is helpful in bulk import of data values from data files. The number and order of data fields in the data file may be different than those in the destination table columns. This is when the BCP data format file comes to help by specifying the order and type of columns for importing the data.
The structure of the format file is represented in the following format.