TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

catalog.get_parameter_values (SSISDB Database)

 

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

Resolves and retrieves the default parameter values from a project and corresponding packages in the Integration Services catalog.

get_parameter_values [ @folder_name = ] folder_name  
     , [ @project_name = ] project_name  
     , [ @package_name = ] package_name  
  [  , [ @reference_id = ] reference_id  ]  
  

[ @folder_name = ] folder_name
The name of the folder that contains the project. The folder_name is nvarchar(128).

[ @project_name = ] project_name
The name of the project where the parameters resides. The project_name is nvarchar(128).

[ @package_name = ] package_name
The name of the package. Specify the package name to retrieve all project parameters and the parameters from a specific package. Use NULL to retrieve all project parameters and the parameters from all packages. The package_name is nvarchar(260).

[ @reference_id = ] reference_id
The unique identifier of an environment reference. This parameter is optional. The reference_id is bigint.

0 (success)

Returns a table that has the following format:

Column nameData typeDescription
object_typesmallintThe type of parameter. The value is 20 for a project parameter and the value is 30 for a package parameter.
parameter_data_typenvarchar(128)The data type of the parameter.
parameter_namesysnameThe name of the parameter.
parameter_valuesql_variantThe value of the parameter.
sensitivebitWhen the value is 1, the parameter value is sensitive. When the value is 0, the parameter value is not sensitive.
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.
value_setbitWhen the value is 1, the parameter value has been assigned. When the value is 0, the parameter value has not been assigned.
System_CAPS_ICON_note.jpg Note


Literal values are displayed in plaintext. NULL is displayed in place of sensitive values.

This stored procedure requires one of the following permissions:

  • READ permissions on the project and, if applicable, READ permission on the referenced environment

  • Membership to the ssis_admin database role

  • Membership to the sysadmin server role

The following list describes some conditions that may raise an error or warning:

  • The package cannot be found in the specified folder or project

  • The user does not have the appropriate permissions

  • The specified environment reference does not exist

Community Additions

ADD
Show:
© 2016 Microsoft