Share via


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.