DSXchange

You can create a server job without inputs. Create a transform stage with no inputs, define a stage var (you don't need to use it) and define a constraint such as "@OUTROWNUM<2" and you are done.

Or create a sequence job, add a routine activity and call your routine from there... sounds like what you want anyway...

I like to use a hashed file stage invoking VOC with the Selection tab having @ID = 'VOC', or a sequential file stage accessing a file that is known to exist (such as uvodbc.config) and a filter of head -1.

Adding the stage variable and including the constraint resolved my issue.


Thanks a lot for all your help..