catalog.projects (SSISDB Database)


THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Displays the details for all projects that appear in the SSISDB catalog.

Column nameData typeDescription
project_idbigintThe unique identifier (ID) of the project.
folder_idbigintThe unique ID of the folder where the project resides.
namesysnameThe name of the project.
descriptionnvarchar(1024)The optional description of the project.
project_format_versionintThe version of SQL Server that was used to develop the project.
deployed_by_sidvarbinary(85)The security identifier (SID) of the user who installed the project.
deployed_by_namenvarchar(128)The name of the user who installed the project.
last_deployed_timedatetimeoffset(7)The date and time at which the project was deployed or redeployed.
created_timedatetimeoffset(7)The date and time at which the project was created.
object_version_lsnbigintThe version of the project. This number is not guaranteed to be sequential.
validation_statuschar(1)The validation status.
last_validation_timedatetimeoffset(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.

System_CAPS_ICON_note.jpg 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.

Community Additions