This table stores the information of the catalog properties
SELECT property_name,property_value
FROM [SSISDB].[internal].Catalog_properties
|
See below
Encryption Algorithm
The type of encryption
algorithm that is used to encrypt sensitive data. The supported values include:
Ø
DES
Ø
TRIPLE_DES
Ø
TRIPLE_DES_3KEY
Ø
DESX
Ø
AES_128
Ø
AES_192
Ø
AES_256
Note: The catalog
database must be in single-user mode in order to change this property.
MAX Project Version
The number of new project versions that will be retained for
a single project. When version cleanup is enabled, older versions beyond this
count will be deleted. By default value it 10 but we can changes it to 999. It
depends on the business requirement.
OPERATION CLEANUP ENABLED
When the value is TRUE, operation
details and operation messages older than RETENTION_WINDOW (days) are deleted
from the catalog. When the value is FALSE, all operation details and operation
messages are stored in the catalog. Note: a SQL Server job performs the
operation cleanup.
RETENTION WINDOW
The number of days that operation
details and operation messages are stored in the catalog. When the value is -1,
the retention window is infinite. Note:
If no cleanup is desired, set OPERATION_CLEANUP_ENABLED to FALSE.
VALIDATION TIMEOUT
Validations will be stopped if they do not complete in the
number of seconds specified by this property.
VERSION CLEANUP ENABLED
When the value is TRUE, only the MAX_PROJECT_VERSIONS number
of project versions is stored in the catalog and all other project versions are
deleted. When the value is FALSE, all project versions are stored in the
catalog. Note: a SQL Server job performs the operation cleanup.
