title: BCP File not loaded completely when Numeric value out of range error occurs for 10 times
body: <p>I am trying to import a tab delimited file in to SQL. One of the field in DB is <code>decimal(15,2)</code>. But the file that I receive may have some exponential values like <code>-2.702159776E17</code> which clearly does not fit for the field I have in DB.</p>
  
  <p>The problem is if there are more than 10 records of that exponential file, BCP is not loading in the complete data. As soon as it is encountering the 10th instance of the exponential value, it is skipping the rest of the file. </p>
  
  <p>I am using below BCP command to load the data:</p>
  
  <pre><code>dbname.dbo.tablename in "filelocation" -c -F 2 -b 10000 -h "TABLOCK" -T -S servername
  </code></pre>
  
  <p>The file I am trying to import has 200,000 records. But we can clearly see that it has processed only 18,000 records, rest are skipped. Output from the BCP as below.</p>
  
  <pre><code>Starting copy...
  SQLState = 22003, NativeError = 0
  Error = [Microsoft][SQL Server Native Client 11.0]Numeric value out of range
  SQLState = 22003, NativeError = 0
  Error = [Microsoft][SQL Server Native Client 11.0]Numeric value out of range
  SQLState = 22003, NativeError = 0
  Error = [Microsoft][SQL Server Native Client 11.0]Numeric value out of range
  SQLState = 22003, NativeError = 0
  Error = [Microsoft][SQL Server Native Client 11.0]Numeric value out of range
  SQLState = 22003, NativeError = 0
  Error = [Microsoft][SQL Server Native Client 11.0]Numeric value out of range
  SQLState = 22003, NativeError = 0
  Error = [Microsoft][SQL Server Native Client 11.0]Numeric value out of range
  SQLState = 22003, NativeError = 0
  Error = [Microsoft][SQL Server Native Client 11.0]Numeric value out of range
  SQLState = 22003, NativeError = 0
  Error = [Microsoft][SQL Server Native Client 11.0]Numeric value out of range
  SQLState = 22003, NativeError = 0
  Error = [Microsoft][SQL Server Native Client 11.0]Numeric value out of range
  SQLState = 22003, NativeError = 0
  Error = [Microsoft][SQL Server Native Client 11.0]Numeric value out of range
  
  18149 rows copied.
  Network packet size (bytes): 4096
  Clock Time (ms.) Total     : 265    Average : (68486.79 rows per sec.)
  </code></pre>