catalog.projects(SSISDB 数据库)catalog.projects (SSISDB Database)

适用范围:SQL Server,包括 Linux Azure SQL 数据库yesAzure SQL 数据仓库no并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

适用对象: yesSQL ServeryesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

显示 SSISDB 目录中显示的所有项目的详细信息。Displays the details for all projects that appear in the SSISDB catalog.

列名Column name 数据类型Data type 描述Description
project_idproject_id bigintbigint 项目的唯一标识符 (ID)。The unique identifier (ID) of the project.
folder_idfolder_id bigintbigint 项目位于其中的文件夹的唯一 ID。The unique ID of the folder where the project resides.
NAMEname sysnamesysname 项目的名称。The name of the project.
descriptiondescription nvarchar(1024)nvarchar(1024) 项目的可选说明。The optional description of the project.
project_format_versionproject_format_version intint 用于开发项目的 SQL ServerSQL Server 版本。The version of SQL ServerSQL Server that was used to develop the project.
deployed_by_siddeployed_by_sid varbinary(85)varbinary(85) 安装了项目的用户的安全标识符 (SID)。The security identifier (SID) of the user who installed the project.
deployed_by_namedeployed_by_name nvarchar(128)nvarchar(128) 安装项目的用户名。The name of the user who installed the project.
last_deployed_timelast_deployed_time datetimeoffset(7)datetimeoffset(7) 部署或重新部署项目的日期和时间。The date and time at which the project was deployed or redeployed.
created_timecreated_time datetimeoffset(7)datetimeoffset(7) 项目的创建日期和时间。The date and time at which the project was created.
object_version_lsnobject_version_lsn bigintbigint 项目的版本。The version of the project. 此数字不保证是按顺序排列的。This number is not guaranteed to be sequential.
validation_statusvalidation_status char(1)char(1) 验证状态。The validation status.
last_validation_timelast_validation_time datetimeoffset(7)datetimeoffset(7) 最后验证的时间。The time of the last validation.

RemarksRemarks

此视图对于目录中的每个项目显示一行。This view displays a row for each project in the catalog.

权限Permissions

此视图需要下列权限之一:This view requires one of the following permissions:

  • 针对项目的 READ 权限READ permission on the project

  • ssis_admin 数据库角色的成员资格Membership to the ssis_admin database role

  • sysadmin 服务器角色的成员资格。Membership to the sysadmin server role.

备注

如果您对项目具有 READ 权限,则也对与该项目关联的所有包和环境引用具有 READ 权限。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.