Environment references Table in SSIS

This table is having environment references for all projects in the SSISDB catalog.

select * from internal.environment_references

  

Reference Type:

This indicates whether the environment can be located in the same folder as the project (relative reference) or in a different folder (absolute reference).

 When the value is R, the environment is located by using a relative reference.

When the value is A, the environment is located by using an absolute reference.

A project can have relative or absolute environment references. Relative references refer to the environment by name and require hat it resides in the same folder as the project. Absolute references refer to the environment by name and folder, and may refer to environments that reside in a different folder than the project. A project can reference multiple environments.