Abort the job when source file is empty in FTP

[srividhya]

Hai
Iam using FTP stage to read the source file. I have to abort the job if the source file is empty. If the iam reading from the sequential file then i can use wc -file name then trigger my job. But using FTP plugin stage I have no clue how to handle this.
I can do the rowcount after the job and abort the job, but is there any other way to do this

Thanks
Srividhya

[vcannadevula]

Hai
Iam using FTP stage to read the source file. I have to abort the job if the source file is empty. If the iam reading from the sequential file then i can use wc -file name then trigger my job. But using FTP plugin stage I have no clue how to handle this.
I can do the rowcount after the job and abort the job, but is there any other way to do this

Thanks
Srividhya

First FTP the file. IN the second job execute the Unix command to check the size and if it is zero then abort the job and do the cleanup of the ftped file

[ray.wurlod]

Never abort.

Retain control.

In a job sequence perform the FTP. Then test the size of the result. If this is non-zero, then proceed with the job that processes it.

[srividhya]

Hai Ray,
I never abort my job, if any of my check failures iam inserting a row in the reject table with the reason for that rejection.
But I dont know how to do the check in this case

Thanks
Srividhya

[ray.wurlod]

Use the UNIX command test (with -z option) in an Execute Command activity, or use OpenSeq, FileInfo() and CloseSeq in a Routine activity.

[srividhya]

Thanks Ray,

Iam using Test -s , option -z is to check a string not a file. Am i doing correct .......

Thanks
Srividhya