I want to create a task in MSSql DTS Manage that will Empty/clear a temp table, check another table and look at one of the fields, if that field is NULL, put a entry into the temp table for each of the entries that contains a NULL and send a email. The task is to be run every 45 mins.
I have been able to create the above but the hard part for me is if there are no NULL entries and after running the task the Temp table is empty I dont want a e-mail sent…
Can anyone shed some light on this
