Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Send Mail in SSIS Expand / Collapse
Posted Wednesday, July 18, 2012 10:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 3:32 PM
Points: 48, Visits: 166
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?

Thanks, Jim
Post #1331632
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse