catalog.projects (SSISDB Database)

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

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 SQL Server 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.

Remarks

This view displays a row for each project in the catalog.

Permissions

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.

Opomba

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.