Export (0) Print
Expand All

Catalog Properties Dialog Box

Use the Catalog Properties dialog box to configure the SSISDB catalog. Catalog properties define how sensitive data is encrypted, how operations and project versioning data is retained, and when validation operations time out. The SSISDB catalog is a central storage and administration point for Integration Services projects, packages, parameters, and environments.

You can also view catalog properties in the catalog.catalog_property view, and set the properties by using the catalog.configure_catalog stored procedure. For more information, see catalog.catalog_properties (SSISDB Database) and catalog.configure_catalog (SSISDB Database).

For information on how to create the SSISDB catalog, see Create the SSIS Catalog.

  1. Open SQL Server Management Studio.

  2. Connect Microsoft SQL Server Database Engine.

  3. In Object Explorer, expand the Integration Services node, right-click SSISDB, and then click Properties.

Options

The following table describes certain properties in the dialog box and the corresponding properties in the catalog.catalog_property view.

Property Name (Catalog Properties dialog box)

Property Name (catalog.catalog_property view)

Description

Encryption Algorithm Name

ENCRYPTION_CLEANUP_ENABLED

Specifies the type of encryption that is used to encrypt the sensitive parameter values in the catalog. The following are the possible values:

  • DES

  • TRIPLE_DES

  • TRIPLE_DES_3KEY

  • DESPX

  • AES_128

  • AES_192

  • AES_256 (default)

Validation Timeout (seconds)

VALIDATION_TIMEOUT

Specify the maxium number of seconds a project validation or a package validation can run before it is stopped. The default value is 300 seconds.

Performing the validation is an asynchronous operation. The larger the project or package is, the longer it will take to validate.

For information on validating projects and packages, see Integration Services Data Types in Expressions.

Clean Logs Periodically

OPERATION_CLEANUP_ENABLED

Set the property to True to indicate that the SQL Server Agent job, operations cleanup, runs. Otherwise, set the property to False.

Retention Period (days)

RETENTION_WINDOW

Specify the maximum age of allowable operations data (in days). Data that is older than the specified number of days will be removed by the SQL Agent job, operations cleanup.

Maximum Number of Versions per Project

MAX_PROJECT_VERSIONS

Specify how many versions of a project will be stored in the catalog. Older versions of projects that exceed the maximum will be removed when the project version cleanup job runs.

Community Additions

ADD
Show:
© 2014 Microsoft