Any suggestions? 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.

What do you want to do?

  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.

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)


Encryption Algorithm Name


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

  • DES




  • AES_128

  • AES_192

  • AES_256 (default)

Validation Timeout (seconds)


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


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)


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


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

© 2016 Microsoft