title: SQL Server bulk insert XML format file with Maximum LENGTH
body: <p>I want to set the length to MAX for one of my XML fields.</p>
  
  <p>XML Code:</p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
  &lt;BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;
   &lt;RECORD&gt;
      &lt;FIELD ID="1" xsi:type="CharFixed" LENGTH="3" /&gt;
      &lt;FIELD ID="2" xsi:type="CharFixed" LENGTH="MAXLENGTH"  /&gt;
      &lt;FIELD ID="3" xsi:type="CharFixed" LENGTH="10" /&gt;
      &lt;FIELD ID="4" xsi:type="CharFixed" LENGTH="8" /&gt;
  
   &lt;/RECORD&gt;
   &lt;ROW&gt;
      &lt;COLUMN SOURCE="1" NAME="Field1" xsi:type="SQLNVARCHAR"/&gt;
      &lt;COLUMN SOURCE="2" NAME="Field2" xsi:type="SQLNVARCHAR"/&gt;
      &lt;COLUMN SOURCE="3" NAME="Field3" xsi:type="SQLNVARCHAR"/&gt;
      &lt;COLUMN SOURCE="4" NAME="Field4" xsi:type="SQLNVARCHAR"/&gt;   
   &lt;/ROW&gt;
  &lt;/BCPFORMAT&gt;
  </code></pre>
  
  <p>But 'MAXLENGTH' does not seem to work. </p>
  
  <p>Error message:</p>
  
  <pre><code>bad value MAXLENGTH for attribute "LENGTH"
  </code></pre>
  
  <p>Any suggestions on how to put the LENGTH to maximum ?</p>