| title | catalog.projects (SSISDB Database) |
|---|---|
| description | catalog.projects (SSISDB Database) |
| author | chugugrace |
| ms.author | chugu |
| ms.date | 03/14/2017 |
| ms.service | sql |
| ms.subservice | integration-services |
| ms.topic | reference |
[!INCLUDEsqlserver-ssis]
Displays the details for all projects that appear in the SSISDB catalog.
| Column name | Data type | Description |
|---|---|---|
| project_id | bigint | The unique identifier (ID) of the project. |
| folder_id | bigint | The unique ID of the folder where the project resides. |
| name | sysname | The name of the project. |
| description | nvarchar(1024) | The optional description of the project. |
| project_format_version | int | The version of [!INCLUDEssNoVersion] that was used to develop the project. |
| deployed_by_sid | varbinary(85) | The security identifier (SID) of the user who installed the project. |
| deployed_by_name | nvarchar(128) | The name of the user who installed the project. |
| last_deployed_time | datetimeoffset(7) | The date and time at which the project was deployed or redeployed. |
| created_time | datetimeoffset(7) | The date and time at which the project was created. |
| object_version_lsn | bigint | The version of the project. This number is not guaranteed to be sequential. |
| validation_status | char(1) | The validation status. |
| last_validation_time | datetimeoffset(7) | The time of the last validation. |
This view displays a row for each project in the catalog.
This view requires one of the following permissions:
-
READ permission on the project
-
Membership to the ssis_admin database role
-
Membership to the sysadmin server role.
Note
If you have READ permission on a project, you also have READ permission on all of the packages and environment references associated with that project. Row-level security is enforced; only rows that you have permission to view are displayed.