You might find Marcin Policht's series on SSIS helpful. Here is the
SendMail discussion:
http://www.databasejournal.com/features/mssql/article.php/3646986/SQL-Server-2005-Integration-Services---Part-39---Send-Mail-Task.htm
Another site dedicated to helping you use SSIS is: http://www.sqlis.com/
Because problems are not always predictable, it is possible that you will
get a massive number of errors due to someone making a simple mistake. A
giant email is not always that friendly to deal with.
Therefore, I would suggest that if there are any errors you might:
1. Save the problems to a file and email the link to the DBA.
2. Save the problems to a table in SQL Server and email the DBA to
investigate the saved problem rows.
FWIW,
RLF
Post by FsbHello,
I have a conditional split that splits records into valid and invalid.
How do i send an email of invalid records to the DBA?