How to get Value File Name from Parameter Set

MrBlack · Post by **MrBlack** » Mon Mar 16, 2015 2:52 pm

Is there a way at run-time (inside a user variable activity, etc..), to get the Value File Name value from a parameter set?

I build my parameter set values with a DEV/TEST/PROD version of each parameter. This makes it simple when I run to select which values to use. I would like to get this "target environment" selection and include it in the subject of an email.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 16, 2015 3:23 pm

I'd probably use a server routine with DSJ.ME as the job handle argument. These can be invoked from user variables. The "value" of the Parameter Set (DSGetParamInfo() function) is the name of the values file, if one was used.