IBCPSession::BCPWriteFmt (OLE DB)

Writes format information for each column to the format file.


      const wchar_t *pwszFormatFile);


The format file specifies the data format of a data file created by bulk copy. Calls to the IBCPSession::BCPColumns and IBCPSession::BCPColFmt methods define the format of the data file. The BCPWriteFmt method saves this definition in the file referenced by the pwszFormatFile argument.

The BCPWriteFmt method can save the format files in either xml or text format. This must be indicated by using the BCP_OPTION_XML control option with the IBCPSession::BCPControl method.

To load a saved format file, use the IBCPSession::BCPReadFmt method.


The format file produced by the BCPWriteFmt method is supported only by versions of the bcp utility distributed with SQL Server version 7.0 or later.


  • pwszFormatFile[in]
    The path and file name of the file containing the format values for the data file.

Return Code Values

  • S_OK
    The method succeeded.

  • E_FAIL
    A provider-specific error occurred; for detailed information, use the ISQLServerErrorInfo interface.

    Out-of-memory error.

    The call to the method was unexpected. For example, the IBCPSession::BCPInit method was not called before calling this method.

See Also


Other Resources