TechNet
Export (0) Print
Expand All

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 nameData typeDescription
execution_parameter_idbigintUnique identifier (ID) of the execution parameter.
execution_idbigintUnique ID for the instance of execution.
object_typesmallintWhen 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_typenvarchar(128)The data type of the parameter.
parameter_namesysnameThe name of the parameter.
parameter_valuesql_variantThe value of the parameter. When sensitive is 0, the plaintext value is shown. When sensitive is 1, the NULL value is displayed.
sensitivebitWhen the value is 1, the parameter value is sensitive. When the value is 0, the parameter value is not sensitive.
requiredbitWhen 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_setbitWhen the value is 1, the parameter value has been assigned. When the value is 0, the parameter value has not been assigned.
runtime_overridebitWhen 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.

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 permission on the instance of execution

  • Membership to the ssis_admin database role

  • Membership to the sysadmin server role

System_CAPS_ICON_note.jpg 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.

Community Additions

ADD
Show:
© 2016 Microsoft