April 25, 2017 at 12:46 pm
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?
April 25, 2017 at 12:57 pm
ajkarora - Tuesday, April 25, 2017 12:46 PMI 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.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply