catalog.catalog_properties(SSISDB 数据库)catalog.catalog_properties (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 目录的属性。Displays the properties of the Integration ServicesIntegration Services catalog.

列名Column name 数据类型Data type 描述Description
property_nameproperty_name nvarchar(256)nvarchar(256) 目录属性的名称。The name of the catalog property.
property_valueproperty_value nvarchar(256)nvarchar(256) 目录属性的值。The value of the catalog property.

RemarksRemarks

此视图对于每个目录属性显示一行。This view displays a row for each catalog property.

属性名称Property Name 描述Description
DEFAULT_EXECUTION_MODEDEFAULT_EXECUTION_MODE 服务器范围的默认包执行模式 - Server (0) 或 Scale Out (1)。The server-wide default execution mode for packages - Server (0) or Scale Out (1).
ENCRYPTION_ALGORITHMENCRYPTION_ALGORITHM 用于加密敏感数据的加密算法的类型。The type of encryption algorithm that is used to encrypt sensitive data. 支持的值包括:DESTRIPLE_DESTRIPLE_DES_3KEYDESXAES_128AES_192AES_256The supported values include: DES, TRIPLE_DES, TRIPLE_DES_3KEY, DESX, AES_128, AES_192, and AES_256. 注意:要更改此属性,目录数据库必须处于单用户模式。Note: The catalog database must be in single-user mode in order to change this property.
IS_SCALEOUT_ENABLEDIS_SCALEOUT_ENABLED 值如果为 True,SSIS Scale Out 功能为启用状态。When the value is True, the SSIS Scale Out feature is enabled. 如果未启用 Scale Out,该属性可能不会显示在视图中。If you have not enabled Scale Out, this property may not appear in the view.
MAX_PROJECT_VERSIONSMAX_PROJECT_VERSIONS 为单个项目保留的新项目版本的数量。The number of new project versions that are retained for a single project. 当启用了版本清理时,超出了此计数的较早版本将被删除。When version cleanup is enabled, older versions beyond this count are deleted.
OPERATION_CLEANUP_ENABLEDOPERATION_CLEANUP_ENABLED 当值为 TRUE 时,将从目录中删除超过 RETENTION_WINDOW (天)的操作详细信息和操作消息。When the value is TRUE, operation details and operation messages older than RETENTION_WINDOW (days) are deleted from the catalog. 当值为 FALSE 时,将在目录中存储所有操作详细信息和操作消息。When the value is FALSE, all operation details and operation messages are stored in the catalog. 注意:SQL ServerSQL Server 作业执行清理操作。Note: a SQL ServerSQL Server job performs the operation cleanup.
RETENTION_WINDOWRETENTION_WINDOW 操作详细信息和操作消息存储在目录中的天数。The number of days that operation details and operation messages are stored in the catalog. 如果值为 -1,则保持期窗口是无限的。When the value is -1, the retention window is infinite. 注意:如果无需清理,将 OPERATION_CLEANUP_ENABLED 设置为 FALSE 。Note: If no cleanup is desired, set OPERATION_CLEANUP_ENABLED to FALSE.
SCHEMA_BUILDSCHEMA_BUILD SSISDB 目录数据库架构的生成号。The build number of the SSISDB catalog database schema. 每当创建或升级 SSISDB 目录,此号相应更改。This number changes whenever the SSISDB catalog is created or upgraded.
SCHEMA_VERSIONSCHEMA_VERSION SSISDB 目录数据库架构的主版本号。The major version number of the SSISDB catalog database schema. 每当创建 SSISDB 目录或升级主版本,此号相应更改。This number changes whenever the SSISDB catalog is created or the major version is upgraded.
VALIDATION_TIMEOUTVALIDATION_TIMEOUT 如果验证没有在该属性指定的秒数内完成,则将停止验证。Validations are stopped if they do not complete in the number of seconds specified by this property.
SERVER_CUSTOMIZED_LOGGING_LEVELSERVER_CUSTOMIZED_LOGGING_LEVEL Integration ServicesIntegration Services 服务器的默认自定义日志记录级别。The default customized logging level for the Integration ServicesIntegration Services server. 如果未创建任何自定义日志记录级别,此属性可能不会显示在视图中。If you have not created any customized logging levels, this property may not appear in the view.
SERVER_LOGGING_LEVELSERVER_LOGGING_LEVEL Integration ServicesIntegration Services 服务器的默认日志记录级别。The default logging level for the Integration ServicesIntegration Services server.
SERVER_OPERATION_ENCRYPTION_LEVELSERVER_OPERATION_ENCRYPTION_LEVEL 如果值为 1 (PER_EXECUTION),为每个执行创建用于保护敏感执行参数和执行日志的证书和对称密钥 。When the value is 1 (PER_EXECUTION), the certificate and symmetric key used for protecting sensitive execution parameters and execution logs are created for each execution. 如果值为 2 (PER_PROJECT),则为每个项目创建一次证书和对称密钥 。When the value is 2 (PER_PROJECT), the certificate and symmetric key are created one time for each project. 有关此属性的详细信息,请参阅 SSIS 存储过程 catalog.cleanup_server_log 的注解。For more info about this property, see the Remarks for the SSIS stored procedure catalog.cleanup_server_log.
VERSION_CLEANUP_ENABLEDVERSION_CLEANUP_ENABLED 值为 TRUE 时,将仅在目录中存储数量为 MAX_PROJECT_VERSIONS 的项目版本,而删除所有其他项目版本。When the value is TRUE, only the MAX_PROJECT_VERSIONS number of project versions are stored in the catalog and all other project versions are deleted. 如果值为 FALSE ,将在目录中存储所有项目版本。When the value is FALSE, all project versions are stored in the catalog. 注意:SQL ServerSQL Server 作业执行清理操作。Note: a SQL ServerSQL Server job performs the operation cleanup.

权限Permissions

此视图需要下列权限之一:This view requires one of the following permissions:

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

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