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.