I have a question regarding a SSIS package that I created. Pretty much it takes Excel Source files and it writes the data to SQL Table. The source file has over 10K records. One of the field has length of 75 characters and there are times where that fields exceeds 75 characters and the package fails. Is there anyway to capture the specific record that failed? Instead of going over 10K records?
If you can't lengthen the destination column use a Derived Column Transform, add the Left Function on the column with 75 for the Length parameter. You could also pipe error rows to a file.