catalog.packages(SSISDB 数据库)catalog.packages (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 packages that appear in the SSISDB catalog.

列名Column name 数据类型Data type 描述Description
package_idpackage_id bigintbigint 包的唯一标识符 (ID)。The unique identifier (ID) of the package.
NAMEname nvarchar(256)nvarchar(256) 包的唯一名称。The unique name of the package.
package_guidpackage_guid uniqueidentifieruniqueidentifier 标识包的全局唯一标识符 (GUID)。The globally unique identifier (GUID) that identifies the package.
descriptiondescription nvarchar(1024)nvarchar(1024) 包的可选说明。An optional description of the package.
package_format_versionpackage_format_version intint 用于开发包的 SQL ServerSQL Server 版本。The version of SQL ServerSQL Server that was used to develop the package.
version_majorversion_major intint 包的主版本。The major version of the package.
version_minorversion_minor intint 包的次版本。The minor version of the package.
version_buildversion_build intint 包的内部版本号。The build version of the package.
version_commentsversion_comments nvarchar(1024)nvarchar(1024) 包版本的可选注释。Optional comments on the version of the package.
version_guidversion_guid uniqueidentifieruniqueidentifier 唯一标识包版本的 GUID。The GUID that uniquely identifies the version of the package.
project_idproject_id bigintbigint 项目的唯一 ID。The unique ID of the project.
entry_pointentry_point bitbit 值为 1 表示直接启动包。The value of 1 signifies that the package is meant to be started directly. 值为 0 表示该包由另一个包通过“执行包”任务启动。The value of 0 signifies that the package is meant to be started by another package with the Execute Package task. 默认值是 1The default value is 1.
validation_statusvalidation_status char(1)char(1) 验证的状态。The status of the validation.
last_validation_timelast_validation_time datetimeoffset(7)datetimeoffset(7) 最后验证的时间。The time of the last validation.


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


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

  • 针对相应项目的 READ 权限READ permission on the corresponding 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.