catalog.execution_parameter_values(SSISDB 数据库)catalog.execution_parameter_values (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 actual parameter values that are used by Integration ServicesIntegration Services packages during an instance of execution.

列名Column name 数据类型Data type 描述Description
execution_parameter_idexecution_parameter_id bigintbigint 执行参数的唯一标识符 (ID)。Unique identifier (ID) of the execution parameter.
execution_idexecution_id bigintbigint 执行实例的唯一 ID。Unique ID for the instance of execution.
object_typeobject_type smallintsmallint 当值为 20 时,参数为项目参数。When the value is 20, the parameter is a project parameter. 当值为 30 时,参数为包参数。When the value is 30, the parameter is a package parameter. 当值为 50 时,参数为以下参数之一:When the value is 50, the parameter is one of the following:






parameter_data_typeparameter_data_type nvarchar(128)nvarchar(128) 参数的数据类型。The data type of the parameter.
parameter_nameparameter_name sysnamesysname 参数名。The name of the parameter.
parameter_valueparameter_value sql_variantsql_variant 参数的值。The value of the parameter. 当 sensitive 为 0 时,显示纯文本值。When sensitive is 0, the plaintext value is shown. 当 sensitive 为 1 时,显示 NULL 值。When sensitive is 1, the NULL value is displayed.
sensitivesensitive bitbit 当值为 1 时,参数值是敏感的。When the value is 1, the parameter value is sensitive. 当值为 0 时,参数值是不敏感的。When the value is 0, the parameter value is not sensitive.
requiredrequired bitbit 如果值为 1,则需要参数值才能开始执行。When the value is 1, the parameter value is required in order to start the execution. 如果值为 0,则不需要参数值即可开始执行。When the value is 0, the parameter value is not required to start the execution.
value_setvalue_set bitbit 如果值为 1,则已分配参数值。When the value is 1, the parameter value has been assigned. 如果值为 0,则尚未分配参数值。When the value is 0, the parameter value has not been assigned.
runtime_overrideruntime_override bitbit 当值为 1 时,会在开始执行之前更改参数值的原始值。When the value is 1, the parameter value was changed from the original value before the execution was started. 当值为 0 时,参数值为设置的原始值。When the value is 0, the parameter value is the original value that was set.


此视图对于目录中的每个执行参数显示一行。This view displays a row for each execution parameter in the catalog. 执行参数值时在单个执行实例中分配给项目参数或包参数的执行参数值。An execution parameter value is the value that is assigned to a project parameter or package parameter during a single instance of execution.


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

  • 针对执行实例的 READ 权限READ permission on the instance of execution

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