catalog.configure_catalog(SSISDB 数据库)catalog.configure_catalog (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 目录。Configures the Integration ServicesIntegration Services catalog by setting a catalog property to a specified value.

语法Syntax

catalog.configure_catalog [ @property_name = ] property_name , [ @property_value = ] property_value  

参数Arguments

[ @property_name = ] property_name [ @property_name = ] property_name
目录属性的名称。The name of the catalog property. Property_name 为 nvarchar(255) 。The property_name is nvarchar(255). 有关可用属性的详细信息,请参阅 catalog.catalog_properties(SSISDB 数据库)For more information about available properties, see catalog.catalog_properties (SSISDB Database).

[ @property_value = ] property_value [ @property_value = ] property_value
目录属性的值。The value of the catalog property. Property_value 为 nvarchar(255) 。The property_value is nvarchar(255). 有关属性值的详细信息,请参阅 catalog.catalog_properties(SSISDB 数据库)For more information about property values, see catalog.catalog_properties (SSISDB Database)

返回代码值Return Code Values

0(成功)或 1(失败)0 (success) or 1 (failure)

结果集Result Sets

NoneNone

RemarksRemarks

此存储过程确定 property_value 对于每个 property_name 是否有效 。This stored procedure determines whether the property_value is valid for each property_name.

仅当没有活动的执行(如挂起、排队、正在运行、暂停的执行)时,才能执行此存储过程。This stored procedure can be performed only when there are no active executions, such as pending, queued, running, and paused executions.

正在配置目录时,所有其他目录存储过程都将失败,并显示错误消息“当前正在配置服务器”。While the catalog is being configured, all other catalog stored procedures fail with the error message "Server is currently being configured."

当配置目录时,将向操作记录中写入一个条目。When the catalog is configured, an entry is written to the operation log.

权限Permissions

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

  • 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 property does not exist

  • 属性值无效The property value is invalid