title: Bulk Insert column is too long
body: <p>I have a text file with fixed length data.  Here's my table:</p>
  
  <pre><code>create table myBulkInsert(
  MaxData Varchar(Max)
  )
  </code></pre>
  
  <p>x.fmt contains:</p>
  
  <pre><code>10.0
  1
  1       SQLCHAR             8       0       ""   1     MaxData                SQL_Latin1_General_CP1_CI_AS
  </code></pre>
  
  <p>When I issue the following:</p>
  
  <pre><code>bulk insert myBulkInsert
  from 'C:\inetpub\ftproot\TextFile.txt'
  WITH (
      FORMATFILE = 'C:\inetpub\ftproot\Client.fmt'
  );
  </code></pre>
  
  <p>I get:</p>
  
  <blockquote>
    <p>Msg 4866, Level 16, State 17, Line 1 The bulk load failed. The column
    is too long in the data file for row 1, column 1. Verify that the
    field terminator and row terminator are specified correctly. Msg 7399,
    Level 16, State 1, Line 1 The OLE DB provider "BULK" for linked server
    "(null)" reported an error. The provider did not give any information
    about the error. Msg 7330, Level 16, State 2, Line 1 Cannot fetch a
    row from OLE DB provider "BULK" for linked server "(null)".</p>
  </blockquote>
  
  <p>What's odd is that I'm using Bulk Insert with a comma delimited text file and it works great, so I don't think it's a permissions error.</p>
  
  <p>The reason why I just have it as 1 field with a max value is to simplify the example.
  As soon as I get this 1 field working, I'll change the layout to include all the fields and their lengths.</p>