catalog.set_environment_variable_value(SSISDB 数据库)catalog.set_environment_variable_value (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 value of an environment variable in the Integration ServicesIntegration Services catalog.


catalog.set_environment_variable_value [ @folder_name = ] folder_name  
    , [ @environment_name = ] environment_name  
    , [ @variable_name = ] variable _name  
    , [ @value = ] 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).

[ @value = ] value [ @value = ] value
环境变量的值。The value of the environment variable. value 为 sql_variant 。The value is sql_variant.

返回代码值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 user does not have appropriate permissions