DSXchange

Hi all,

How do we set parameter value by reading the value from Database? This is useful when the config table related to Job is in Database and want to update table or read the table to assign it to parameter.

Regards,
Srini.

I don't believe this is possible directly within a parallel job. I do this using Sequence jobs and UserVariable Activity stages. From what I understand of your need, you'd want a parallel job that performs your database query and outputs the result to a file, then using a UserVariable Activity stage, execute a ReadFile routine to pull the value from the file and store it in a variable. Then in the same sequence execute the parallel job which you have that "Dynamic" parameter and set the parameter value as the UserVariable.