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
Rotine Activity triggers
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Tue Aug 21, 2007 5:39 am
- Location: Bangalore, India
Re: Rotine Activity triggers
Can you do some check whether the problem is while reading the empty file or with the return value ?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
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.