Hi ... gotta question.
I just completed a very simple SSIS package. Basically, it reads a CSV file, loads it into a database table, and if the package fails, it sends an email.
Here is the problem: in Data Flow, I have another "data flow destination" if a CSV input file record cannot get converted. I do this to find out which record is in error. It works as advertised, but maybe too well. When I test it with a bogus record in my input CSV file, the good ones get loaded into the table and the bad one gets routed to the error file. My problem is there is no email alerting me of this since that happens in Control Flow. But at the same time, there is no apparent way to alert SSIS that this package should end with an error at the end of processing.
Any idea how I can send an email when an erroneous record occurs?