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


catalog.set_environment_variable_protection [ @folder_name = ] folder_name  
    , [ @environment_name = ] environment_name  
    , [ @variable_name = ] variable_name  
    , [ @sensitive = ] sensitive  


[ @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).

[ @sensitive = ] sensitive [ @sensitive = ] sensitive
指示变量是否包含敏感值。Indicates whether the variable contains a sensitive value or not. 使用值 1 表示环境变量的值是敏感值,值为 0 表示该值不是敏感值。Use a value of 1 to indicate that the value of the environment variable is sensitive or a value of 0 to indicate that it is not. 存储敏感值时将对其加密。A sensitive value is encrypted when it is stored. 不敏感的值以纯文本形式存储。A value that is not sensitive is stored in plaintext. sensitive 参数为 bit 。The sensitive parameter is bit.

返回代码值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 the appropriate permissions