I need to create a DTS package that sends out an email based on a query.
<br>SELECT @Count= count(*) FROM employee WHERE site = 1
If @Count=0 I don't want an email to be sent. If @Count>=1 then the email should be sent out.
How do I set up the package to reflect this?