title: SQL Server: how do I find which column/row gave me an error?
body: <p>Does anyone have any hints on the best way to find the source of an conversion or truncation error such as:</p>
  
  <ul>
  <li>Error converting data type varchar to numeric.</li>
  <li>String or binary data would be truncated. The statement has been terminated.</li>
  </ul>
  
  <p>When I'm inserting batches of data, I'll get these type of errors, and it then becomes a educated guessing game as to what column is having problems, and then what row in my data is the culprit. Any advice? </p>