| title | catalog.environments (SSISDB Database) |
|---|---|
| description | catalog.environments (SSISDB Database) |
| author | chugugrace |
| ms.author | chugu |
| ms.date | 03/04/2017 |
| ms.service | sql |
| ms.subservice | integration-services |
| ms.topic | reference |
[!INCLUDEsqlserver-ssis]
Displays the environment details for all environments in the [!INCLUDEssISnoversion] catalog. Environments contain variables that can be referenced by [!INCLUDEssISnoversion] projects.
| Column name | Data type | Description |
|---|---|---|
| environment_id | bigint | The unique identifier (ID) of the environment. |
| name | sysname | The name of the environment. |
| folder_id | bigint | The unique ID of the folder in which the environment resides. |
| description | nvarchar(1024) | The description of the environment. This value is optional. |
| created_by_sid | varbinary(85) | The security identifier (SID) of the user who created the environment. |
| created_by_name | nvarchar(128) | The name of the user who created the environment. |
| created_time | datetimeoffset | The date and time at which the environment was created. |
This view displays a row for each environment in the catalog. Environment names are only unique with respect to the folder in which they are located. For example, an environment named E1 can exist in more than one folder in the catalog, but each folder can have only one environment named E1.
This view requires one of the following permissions:
-
READ permission on the environment
-
Membership to the ssis_admin database role
-
Membership to the sysadmin server role
Note
Row-level security is enforced; only rows that you have permission to view are displayed.