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?
Instead of failing your package, you can choose to redirect errors to an error table. Have a look here, for example.