I'm working on a SSIS project in which there are several steps.
One of those steps is a query, making some modifications to the data, and then it inserts values into several tables.
My problem is that I want all the data to be inserted, ignoring some problem that may rise from this, like primary keys, etc. I also have configured a mail notification in case this happens, which is working, but the data keeps truncating in a exception when the data is being written.
I've tried configuring on "ignore failure", and got nothing.
I also tried another solutions that other users have posted (like this post:
SSIS 2005 - Ignore row insert failures )
I've tried
Problem state (doesn't finish processing):
This wrote 500 lines, failed on the 501 and that's it, doesn't even finish the process.
Any suggestions will help