catalog.projects (SSISDB Database)

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. The versions may include SQL Server 2005 Beta (1), SQL Server 2005 (2), SQL Server 2008 (3), or SQL Server 2012 (4).
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.

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.