catalog.set_environment_variable_property(SSISDB 数据库)catalog.set_environment_variable_property (SSISDB Database)

适用范围:SQL Server,包括 Linux Azure SQL 数据库yesAzure SQL 数据仓库no并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

适用对象: yesSQL ServeryesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Integration ServicesIntegration Services 目录中设置环境变量的属性。Sets the property of an environment variable in the Integration ServicesIntegration Services catalog.


catalog.set_environment_variable_property [ @folder_name = ] folder_name  
    , [ @environment_name = ] environment_name  
    , [ @variable_name = ] variable_name  
    , [ @property_name = ] property_name  
    , [ @property_value = ] property_value  


[ @folder_name = ] folder_name [ @folder_name = ] folder_name
包含环境的文件夹的名称。The name of the folder that contains the environment. folder_namenvarchar(128)The folder_name is nvarchar(128).

[ @environment_name = ] environment_name [ @environment_name = ] environment_name
环境的名称。The name of the environment. environment_name 为 nvarchar(128) 。The environment_name is nvarchar(128).

[ @variable_name = ] variable_name [ @variable_name = ] variable_name
环境变量的名称。The name of the environment variable. variable_name 为 nvarchar(128) 。The variable_name is nvarchar(128).

[ @property_name = ] property_name [ @property_name = ] property_name
环境变量属性的名称。The name of the environment variable property. property_name 为 nvarchar(128) 。The property_name is nvarchar(128).

[ @property_value = ] property_value [ @property_value = ] property_value
环境变量属性的值。The value of the environment variable property. property_value 为 nvarchar(4000) 。The property_value is nvarchar(4000).

返回代码值Return Code Value

0(成功)0 (success)

结果集Result Sets



此存储过程需要下列权限之一:This stored procedure requires one of the following permissions:

  • 针对环境的 READ 和 MODIFY 权限READ and MODIFY permissions on the environment

  • ssis_admin 数据库角色的成员资格Membership to the ssis_admin database role

  • sysadmin 服务器角色的成员资格Membership to the sysadmin server role

错误和警告Errors and Warnings

下面的列表描述了一些可能引发错误或警告的情况:The following list describes some conditions that may raise an error or warning:

  • 文件夹名称无效The folder name is not valid

  • 环境名称无效The environment name is not valid

  • 环境变量名称无效The environment variable name is not valid

  • 环境变量属性名称无效The environment variable property name is not valid

  • 用户没有相应的权限The user does not have the appropriate permissions


在这一版本中,仅可设置 Description 属性。In this release, only the Description property can be set. Description 属性的属性值不能超过 4000 个字符。The property value for the Description property cannot exceed 4000 characters.