Share via


catalog.execution_parameter_values (SSISDB Database)

Displays the actual parameter values that are used by Integration Services packages during an instance of execution.

Column name

Data type

Description

execution_parameter_id

bigint

Unique identifier (ID) of the execution parameter.

execution_id

bigint

Unique ID for the instance of execution.

object_type

smallint

When the value is 20, the parameter is a project parameter. When the value is 30, the parameter is a package parameter.

When the value is 50, the parameter is one of the following.

  • LOGGING_LEVEL

  • DUMP_ON_ERROR

  • DUMP_ON_EVENT

  • DUMP_EVENT_CODE

  • CALLER_INFO

  • SYNCHRONIZED

parameter_data_type

nvarchar(128)

The data type of the parameter.

parameter_name

sysname

The name of the parameter.

parameter_value

sql_variant

The value of the parameter. When sensitive is 0, the plaintext value is shown. When sensitive is 1, the NULL value is displayed.

sensitive

bit

When the value is 1, the parameter value is sensitive. When the value is 0, the parameter value is not sensitive.

required

bit

When the value is 1, the parameter value is required in order to start the execution. When the value is 0, the parameter value is not required to start the execution.

value_set

bit

When the value is 1, the parameter value has been assigned. When the value is 0, the parameter value has not been assigned.

runtime_override

bit

When the value is 1, the parameter value was changed from the original value before the execution was started. When the value is 0, the parameter value is the original value that was set.

Remarks

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.

Permissions

This view requires one of the following permissions:

  • READ permission on the instance of execution

  • Membership to the ssis_admin database role

  • Membership to the sysadmin server role

Note

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.