DSXchange

Hi,

I have a sequence like this.

JobActivity --> Routine Activity

JobActivity calls a simple job. Job Output will be written to a textfile.
Routine Activity calls a custom routine i.e. reads the ouput of step 1 text file. The two output possibilities of textfile is 1) it may have empty data 2) it may have few records.

Routine is working fine when text file has some data (i.e. return value <> 0). When text file has empty data it is directly going to Terminate stage but it is supposed to go to success link.

How can I write a expression to read the empty data.

However, I have tried following options

Return values

1) = ' '
2) =" "
3) =@NULL

It is not working with above options.

Can anybody suggest me please.

Thanks

Suggest more information is needed. Post the complete Sequence design and the details of what the routine does and the triggers used.

rajendharreddy wrote: When text file has empty data it is directly going to Terminate stage but it is supposed to go to success link.
How can I write a expression to read the empty data.

Return values
1) = ' '
2) =" "
3) =@NULL

Can you do some check whether the problem is while reading the empty file or with the return value ?

If the problem is while reading the empty file, before you start the file reading process, obtain the count of records and decide the next step.

If you need further help, provide more info.