Use Environment Variable in a transformer

[brindavoine]

Hello all,

I found out how to give the right value to my environment variables, with Basic code. I now have a problem with the use of these variables.

It's OK if I want to use them in a file name : #$Variable#

But there's something I don't understand inside a transformer : to fill an output field, I can use the value of an input field, I can use a function, I can use system variables... I can also use the job parameters. There's a pop up box with the list of the job parameters. There's no problem if take a "normal" parameter, but if I choose an environment variable (which is in the list as $Variable), I can't compile the job.

Is there a solution ?

Thank you.

 

[vmcburney]

You need to add the environment variable to your list of job parameters before you can use it. There is an "Add Environment Variable" button on the job parameters form. You then set it to the value of $ENV (environment value) or $PROJDEF (project default) to set the job parameter to the value of the environment variable at run time.

There is a FAQ on project specific environment variables over on

http://www.dsxchange.com.