catalog.folders (SSISDB Database)
Displays the folders in the Integration Services catalog.
|Column name||Data type||Description|
|id||bigint||The unique identifier of the folder.|
|name||sysname(nvarchar(128)||The name of the folder, which is unique within the Integration Services catalog.|
|description||nvarchar(1024)||The description of the folder.|
|created_by_sid||varbinary(85)||The security identifier (SID) of the user who created the folder.|
|created_by_name||nvarchar(128)||The name of the user who created the folder.|
|created_time||datetimeoffset(7)||The date and time at which the folder was created.|
This view displays a row for each folder in the catalog.
This view requires one of the following permissions:
READ permission on the folder
Membership to the ssis_admin database role
Membership to the sysadmin server role