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
