DSXchange

The main Sequence aborts with 'no such file or directory' error.The sequence calls a job which loads to a sequential file.The file update mode is set to Overwrite.
The sequence has failed this time only with 'no such file or directory' error.we recompiled and re-executed the sequence ,it executed successfully.

Please advice on resolving this issue if it occurs when running the sequence again.

I suggest you post the complete error message as it might contain hints as to the actual cause. Also, if the path or filename to the sequential file are parameterized you need to ensure that they are as expected.

The error message is:
Sequential_File_1,0: Unable to open /data/etldata/etl_parameter: No such file or directory.

The path is not parameterized.it's simply given as /data/etldata/etl_parameter

I'll assume that "/data/etldata/etl_parameter" exists and that access rights are sufficient to open the file (that includes access to "/data" and "/data/etldata"). There is little that can be done now if the problem is no longer reproduceable.