Hello,

I have a conditional split that splits records into valid and invalid.

How do i send an email of invalid records to the DBA?

Fsb schreef:
Outlook ?

--
Luuk

You might find Marcin Policht's series on SSIS helpful. Here is the
SendMail discussion:
http://www.databasejournal.com/featu...-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


"Fsb" <Fountainhead7 (AT) hotmail (DOT) com> wrote