catalog.object_parameters

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 nameData typeDescription
parameter_idbigintThe unique identifier (ID) of the parameter.
project_idbigintThe unique ID of the project.
object_typesmallintThe type of parameter. The value is 20 for a project parameter and the value is 30 for a package parameter.
object_namesysnameThe name of the corresponding project or package.
parameter_namesysname(nvarchar(128))The name of the parameter.
data_typenvarchar(128)The data type of the parameter.
requiredbitWhen 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.
sensitivebitWhen the value is 1, the parameter value is sensitive. When the value is 0, the parameter value is not sensitive.
descriptionnvarchar(1024)An optional description of the package.
design_default_valuesql_variantThe default value for the parameter that was assigned during the design of the project or package.
default_valuesql_variantThe default value that is currently used on the server.
value_typechar(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_setbitWhen the value is 1, the parameter value has been assigned. When the value is 0, the parameter value has not been assigned.
referenced_variable_namenvarchar(128)The name of the environment variable that is assigned to the value of the parameter. The default value is NULL.
validation_statuschar(1)Identified for informational purposes only. Not used in SQL Server 2016.
last_validation_timedatetimeoffset(7)Identified for informational purposes only. Not used in SQL Server 2016.

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.

Community Additions

ADD
Show:
© 2016 Microsoft