Export (0) Print
Expand All

catalog.projects (SSISDB Database)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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:
© 2015 Microsoft