| title | catalog.folders (SSISDB Database) |
|---|---|
| description | catalog.folders (SSISDB Database) |
| author | chugugrace |
| ms.author | chugu |
| ms.date | 03/06/2017 |
| ms.service | sql |
| ms.subservice | integration-services |
| ms.topic | reference |
[!INCLUDEsqlserver-ssis]
Displays the folders in the [!INCLUDEssISnoversion] 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 [!INCLUDEssISnoversion] 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
Note
When you have permission to perform an operation on the server, you also have permission to view information about the operation. Row-level security is enforced; only rows that you have permission to view are displayed.