catalog.execution_parameter_values (SSISDB Database)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.