catalog.object_parameters (SSISDB Database)
Displays the parameters for all packages and projects in the Integration Services catalog.
Column name |
Data type |
Description |
|---|---|---|
parameter_id |
bigint |
The unique identifier (ID) of the parameter. |
project_id |
bigint |
The unique ID of the project. |
object_type |
smallint |
The type of parameter. The value is 20 for a project parameter and the value is 30 for a package parameter. |
object_name |
sysname |
The name of the corresponding project or package. |
parameter_name |
sysname(nvarchar(128)) |
The name of the parameter. |
data_type |
nvarchar(128) |
The data type of the parameter. |
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. |
sensitive |
bit |
When the value is 1, the parameter value is sensitive. When the value is 0, the parameter value is not sensitive. |
description |
nvarchar(1024) |
An optional description of the package. |
design_default_value |
sql_variant |
The default value for the parameter that was assigned during the design of the project or package. |
default_value |
sql_variant |
The default value that is currently used on the server. |
value_type |
char(1) |
Indicates the type of parameter value. This field displays V when parameter_value is a literal value and R when the value is assigned by referencing an environment variable. |
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. |
referenced_variable_name |
nvarchar(128) |
The name of the environment variable that is assigned to the value of the parameter. The default value is NULL. |
validation_status |
char(1) |
Identified for informational purposes only. Not used in SQL Server 2012. |
last_validation_time |
datetimeoffset(7) |
Identified for informational purposes only. Not used in SQL Server 2012. |
Permissions
To see rows in this view, you must have one of the following permissions:
READ permission on the project
Membership to the ssis_admin database role
Membership in the sysadmin server role.
Row-level security is enforced; only rows that you have permission to view are displayed.