I seem to be having an issue wtih a task I have that runs and sends an email should there be a number of errors.
The task is a SQL Task.
The flow is as follows
On Error - Stop Job
On Complete - If Output equal 'No Output' (String) - Stop Job
On Success - Continue with next Task
The problem I have here is whenever I delete the 'On Success' part of the flow and run the job it just automatically puts the 'On Success' part of the flow back in anyway and just processes the entire job.
I basically want it to only continue to the next task if there IS output from the SQL Statement, if its 'No Output' I don't want it to continue otherwise it sends a blank email.
Edited by moderator
| Reason: Not specified