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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy