catalog.validations(SSISDB 数据库)catalog.validations (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

显示 Integration ServicesIntegration Services 目录中所有项目和包验证的详细信息。Displays the details of all project and package validations in the Integration ServicesIntegration Services catalog.

列名Column name 数据类型Data type 描述Description
validation_idvalidation_id bigintbigint 验证的唯一标识符 (ID)。The unique identifier (ID) of the validation.
environment_scopeenvironment_scope Char(1)Char(1) 指示由验证考虑的环境引用。Indicates the environment references that are considered by the validation. 如果值为 A,则验证中包括与项目关联的所有环境引用。When the value is A, all environment references associated with the project are included in the validation. 值为 S 时,只包括一个环境引用。When the value is S, only a single environment reference is included. 当值为 D 时,不包括环境引用,并且每个参数必须有文字默认值才能通过验证。When the value is D, no environment references are included and each parameter must have a literal default value in order to pass validation.
validate_typevalidate_type Char(1)Char(1) 要执行的验证类型。The type of validation to perform. 可能的验证类型为依赖项验证 (D) 或完整验证 (F)。The possible types of validation are dependency validation (D) or full validation (F). 包验证始终是完整验证。Package validation is always full validation.
folder_namefolder_name nvarchar(128)nvarchar(128) 包含对应项目的文件夹的名称。The name of the folder that contains the corresponding project.
project_nameproject_name nvarchar(128)nvarchar(128) 项目的名称。The name of the project.
project_lsnproject_lsn bigintbigint 要对照其进行验证的项目版本。The version of the project that is validated against.
use32bitruntimeuse32bitruntime bitbit 指示是否应使用 32 位运行时在 64 位操作系统上运行包。Indicates if the 32-bit runtime is used to run the package on a 64-bit operating system. 如果值为 1则使用 32 位运行时进行执行。When the value is 1, the execution is performed with the 32-bit runtime. 如果值为 0,则使用 64 位运行库来运行执行过程。When the value is 0, the execution is performed with the 64-bit runtime.
reference_idreference_id bigintbigint 项目用来引用环境的项目环境引用的唯一 ID。Unique ID of the project-environment reference that is used by the project to reference an environment.
operation_typeoperation_type smallintsmallint 操作的类型。The type of operation. 在此视图中显示的操作包括项目验证 (300) 和包验证 (301)。The operations displayed in this view include project validation (300) and package validation (301).
object_nameobject_name nvarhcar(260)nvarhcar(260) 对象的名称。The name of the object.
object_typeobject_type smallintsmallint 对象的类型。The type of object. 该对象可能是一个项目 (20) 或包 (30)。The object may be a project (20) or a package (30).
object_idobject_id bigintbigint 操作影响的对象的 ID。The ID of the object affected by the operation.
start_timestart_time datetimeoffset(7)datetimeoffset(7) 开始操作的时间。The time when the operation started.
end_timeend_time datetimeoffsset(7)datetimeoffsset(7) 操作结束的时间。The time when the operation ended.
statusstatus intint 操作的状态。The status of the operation. 可能的值是已创建 (1)、正在运行 (2)、已取消 (3)、失败 (4)、挂起 (5)、意外结束 (6)、已成功 (7)、停止 (8) 和已完成 (9)。The possible values are created (1), running (2), canceled (3), failed (4), pending (5), ended unexpectedly (6), succeeded (7), stopping (8), and completed (9).
caller_sidcaller_sid varbinary(85)varbinary(85) 如果是使用 Windows 身份验证进行登录的,则为用户的安全 ID (SID)。The security ID (SID) of the user if Windows Authentication was used to log on.
caller_namecaller_name nvarchar(128)nvarchar(128) 执行备份操作的帐户的名称。The name of the account that performed the operation.
process_idprocess_id intint 外部进程的进程 ID(如果适用)。The process ID of the external process, if applicable.
stopped_by_sidstopped_by_sid varbinary(85)varbinary(85) 停止操作的用户的 SID。The SID of the user who stopped the operation.
stopped_by_namestopped_by_name nvarchar(128)nvarchar(128) 停止操作的用户名。The name of the user who stopped the operation.
server_nameserver_name nvarchar(128)nvarchar(128) SQL ServerSQL Server 指定实例的 Windows 服务器和实例信息。The Windows server and instance information for a specified instance of SQL ServerSQL Server.
machine_namemachine_name nvarchar(128)nvarchar(128) 运行服务器实例的计算机名称。The computer name on which the server instance is running.
dump_iddump_id uniqueidentifieruniqueidentifier 执行转储的 ID。The ID of the execution dump.


此视图对于 Integration ServicesIntegration Services 目录中的每个验证显示一行。This view displays one row for each validation in the Integration ServicesIntegration Services catalog.


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

  • 针对相应操作的 READ 权限READ permission on the corresponding operation

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

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


当您具有在服务器上执行操作的权限时,您还具有查看有关此操作的信息的权限。When you have permission to perform an operation on the server, you also have permission to view information about the operation. 将实施行级安全性;只显示您有权查看的行。Row-level security is enforced; only rows that you have permission to view are displayed.