Execution parameter values table in SSISDB

This table stores the information of parameter value which is used during the execution of the package.

SELECT [execution_parameter_id]       ,[execution_id]       ,[object_type]       ,[parameter_data_type]       ,[parameter_name]       ,[parameter_value]       ,[sensitive_parameter_value]       ,[base_data_type]       ,[sensitive]       ,[required]       ,[value_set]       ,[runtime_override]   FROM [SSISDB].[internal].[execution_parameter_values]

See below

  

Let’s see the example

I am executing below package

This package accept two user define parameter

  

Now I am executing this package.

Package execution ID is 23

  

Package completed successfully. See below

  

Now we see the value in the Execution parameter value table