• The format file is:

    <?xml version="1.0"?>

    <BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <RECORD>

    <FIELD ID="1" xsi:type="CharFixed" LENGTH="12"/>

    <FIELD ID="2" xsi:type="CharFixed" LENGTH="12"/>

    <FIELD ID="3" xsi:type="CharFixed" LENGTH="17"/>

    <FIELD ID="4" xsi:type="CharFixed" LENGTH="12"/>

    <FIELD ID="5" xsi:type="CharFixed" LENGTH="12"/>

    <FIELD ID="6" xsi:type="CharFixed" LENGTH="21"/>

    <FIELD ID="7" xsi:type="CharFixed" LENGTH="21"/>

    <FIELD ID="8" xsi:type="CharFixed" LENGTH="21"/>

    <FIELD ID="9" xsi:type="CharFixed" LENGTH="21"/>

    <FIELD ID="10" xsi:type="CharFixed" LENGTH="21"/>

    <FIELD ID="11" xsi:type="CharFixed" LENGTH="20"/>

    <FIELD ID="12" xsi:type="CharTerm" TERMINATOR="\r" LENGTH="2">

    </RECORD>

    <ROW>

    <COLUMN SOURCE="1" NAME="Field1" xsi:type="SQLCHAR" LENGTH="12"/>

    <COLUMN SOURCE="2" NAME="Field2" xsi:type="SQLCHAR" LENGTH="12"/>

    <COLUMN SOURCE="3" NAME="Field2" xsi:type="SQLCHAR" LENGTH="17"/>

    <COLUMN SOURCE="4" NAME="Field2" xsi:type="SQLCHAR" LENGTH="12"/>

    <COLUMN SOURCE="5" NAME="Field2" xsi:type="SQLCHAR" LENGTH="12"/>

    <COLUMN SOURCE="6" NAME="Field2" xsi:type="SQLCHAR" LENGTH="21"/>

    <COLUMN SOURCE="7" NAME="Field2" xsi:type="SQLCHAR" LENGTH="21"/>

    <COLUMN SOURCE="8" NAME="Field2" xsi:type="SQLCHAR" LENGTH="21"/>

    <COLUMN SOURCE="9" NAME="Field2" xsi:type="SQLCHAR" LENGTH="21"/>

    <COLUMN SOURCE="10" NAME="Field2" xsi:type="SQLCHAR" LENGTH="21"/>

    <COLUMN SOURCE="11" NAME="Field2" xsi:type="SQLCHAR" LENGTH="20"/>

    </ROW>

    </BCPFORMAT>

    Why SQL throws error:

    Msg 9436, Level 16, State 48, Line 1

    XML parsing: line 16, character 9, end tag does not match start tag

    It points to </RECORD> as the error location.

    Thanks.