title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
---|---|---|---|---|---|---|---|
catalog.execution_parameter_values (SSISDB Database) |
catalog.execution_parameter_values (SSISDB Database) |
chugugrace |
chugu |
03/04/2017 |
sql |
integration-services |
language-reference |
[!INCLUDEsqlserver-ssis]
Displays the actual parameter values that are used by [!INCLUDEssISnoversion] 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. |
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
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.