DSXchange

I have a parameter set having 6 parameters and 20 value file set. I need to run the job in sequence 20 times with different value file name each time.

I have created a delimited list of value file names as below:

ValueFileName1,ValuefileName2,ValueFileName3.... and so on...

Now I wanted to pass ValueFileName1 at first iteration and ValueFileName2 at second iteration.

I am not getting option to pass the value File Name in the job Activity from StartLoop.$counter.

Is there any way to pass the valuefilename to job activity from loop counter?

No problem. Use an Execute Command activity to read the file (use cat command for example). Remove the line terminator, either using a tr -d command in the pipeline, or using a User Variables activity. You now have a comma-delimited list that the Start Loop activity will be happy with.

Not with the job activity stage unfortunately. It limits you to choosing a value file name from a drop down list. It's not possible to specify a parameter.

As a workaround, you can use the execute command activity to run the dsjob command where you should be able to use $Counter in setting the values file to use.

Mike

One of us is misunderstanding the question. I have assumed it's the same job at every iteration, having a value passed to one of its parameters.

yeah. It will be a same job which needs to be run with different Value File at every Iteration.

To resolve the issue, I have created the file with the values of value file set and reading it using execute command stage and then passing the required value to loop .