I have a task that pulls a file from an FTP site from a ftp file trigger when the file becomes available. However, I also have the Job set to run on a schedule as a backup in case the trigger fails. The problem I am running into is that , if the trigger worked and downloaded the file from the ftp site, which it deletes after success, the scheduled event will produce an error saying the file does not exist and stop the job from going on to the next task. This is fine, but what I want to happen is when the scheduled event runs, if there is no file to download, i want it to say successful, but stop the job instead of going on to the next task. I have unchecked the No file(s) downloaded in the Only selected errors option, but I am having trouble using the Output result in a flow condition. Basically , if the Output says No Output then stop job. This does not seem to work if the task condition is set to: On Success>If Output> String => Value/Variable> where I set the Value to No Output.

When the output column in the job grid or task history says "No output" due to downloading no files, the output is actually an empty string. You should leave the "Value/Variable" field empty. Alternatively you ought to be able to use "If Other Value" to check for the number of files downloaded by PrevTask explicitly being 0, but I just discovered that trying to browse to the appropriate job properties in my Variables dialog crashes the client so I can't easily provide an example of what would then go in the box above.

I have a task that pulls a file from an FTP site from a ftp file trigger when the file becomes available. However, I also have the Job set to run on a schedule as a backup in case the trigger fails. The problem I am running into is that , if the trigger worked and downloaded the file from the ftp site, which it deletes after success, the scheduled event will produce an error saying the file does not exist and stop the job from going on to the next task. This is fine, but what I want to happen is when the scheduled event runs, if there is no file to download, i want it to say successful, but stop the job instead of going on to the next task. I have unchecked the No file(s) downloaded in the Only selected errors option, but I am having trouble using the Output result in a flow condition. Basically , if the Output says No Output then stop job. This does not seem to work if the task condition is set to: On Success>If Output> String => Value/Variable> where I set the Value to No Output.

Did you try bwestons suggestion?

---

Thanks. The Empty String worked perfect.

Thanks. The Empty String worked perfect.

Thanks for confirming!

---