This topic has not yet been rated - Rate this topic

catalog.environments (SSISDB Database)

SQL Server 2012

Displays the environment details for all environments in the Integration Services catalog. Environments contain variables that can be referenced by Integration Services 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.

Remarks

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.

Permissions

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD