My first attempt at SSIS and I need to send an email IF SQL has found
particular situation. I have it writing a text(flat) file of the necessary
extraction but can not see how to send the email only if something was found
and extracted.

You will need to define "A Particular Situation" but in principle yes
this is possible. Your "Situation" may not be as simple as a
Fail/Success. Maybe you are looking for a threshold to be a certain
value and it isn't. In this case you may have something write the value
of your query to a variable and use that in an Expression on a
constraint. This allows you to do conditional branching where it is not
as simple as Fail/Succeed/Complete or you want more flexibility. You
can then use Property Expressions on the SendMail task to further
customise the output that gets sent in the mail.

--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com




[quoted text, click to view]