This table is having the environment variable details for
all environments in the Integration Services catalog.
SELECT ev.variable_id,e.environment_name,ev.name,ev.type,
ev.sensitive,ev.value,ev.sensitive_value
FROM internal.Environment_variables
ev
INNER Join internal.environments e
ON e.environment_id=ev.environment_id
|
Let’s see the example
I have create created two variable see below
These values are store on the Environment variable table.
As per the above example.
No comments:
Post a Comment
If you have any doubt, please let me know.