title: SQL Server: Find out what row caused the TSQL to fail (SSIS)
body: <p>SQL Server 2005 Question:</p>
  
  <p>I'm working on a data conversion project where I'm taking 80k+ rows and moving them from one table to another. When I run the TSQL, it bombs with various errors having to do with converting types, or whatever. Is there a way to find out what row caused the error? </p>
  
  <p>=====================</p>
  
  <h1>UPDATE:</h1>
  
  <p>I'm performing an INSERT INTO TABLE1 (...) SELECT ... FROM TABLE2
  Table2 is just a bunch of varchar fields where TABLE1 has the right types. </p>
  
  <p>This script will be put into a sproc and executed from an SSIS package. The SSIS package first imports 5 large flat files into TABLE2.</p>
  
  <p>Here is a sample error message: "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."</p>
  
  <p>There are many date fields. In TABLE2, there are data values like '02/05/1075' for Birthdate. I want to examine each row that is causing the error, so I can report to the department responsible for the bad data so they can correct it. </p>