title: Why do I get "XML parsing: line 2, character 0, incorrect document syntax" when Bulk Inserting in MS SQL Server
body: <p>I'm doing a BULK INSERT into a table using a FMT format file, but I get the following error:</p>
  
  <pre><code>XML parsing: line 2, character 0, incorrect document syntax
  </code></pre>
  
  <p>Here is my code </p>
  
  <pre><code>BULK INSERT [DM_Flux].[dbo].[Stage] FROM 'C:\temp\data.dat'
  WITH (FORMATFILE = 'C:\temp\FormatBcp.fmt')
  </code></pre>
  
  <p>Here is the formatfile (standard format file, not XML):</p>
  
  <pre><code>10.0
  5
  1   SQLCHAR 0   2   ""  1   Id  ""
  2   SQLCHAR 0   40  ""  2   Name    ""
  3   SQLCHAR 0   50  ""  3   Street  ""
  4   SQLCHAR 0   8   ""  4   StreetNo    ""
  5   SQLCHAR 0   300 "\r\n"  7   BulkData    ""
  </code></pre>
  
  <p>Why do I get an XML error with this?</p>