Originally posted by: rm
You can make job step for that too.
Actually I made that as job step, but the problem I am having is for example:
In the output file, contents are below:
connected to the server;
Connection closed by remote host.
I do'nt think the sql job is considering this as failure of FTP and then it keeps moving to the next step.
BTW, this is a batch file we are using to bring SOA files from the mas90(unix) box to sql server. Please let me know if you have any ideas, thanks!!