Export (0) Print
Expand All

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.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft