catalog.object_parameters (SSISDB Database)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 2017.
last_validation_time datetimeoffset(7) Identified for informational purposes only. Not used in SQL Server 2017.

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.