Creating the SSISDB Catalogs in SSIS 2012

For deploying the SSIS package in 2012 first task is to create the SSISDB catalogs and database. Begin by opening SSMS and navigating to the Integration Services Catalogs folder in Object Explorer.

Right click on the Integration Service Catalogs and select Create Catalogs.

The Create Catalogs dialog box will appear, showing us that the name of the database will be SSISDB. (We can't change the name.) In the dialog box, specify the password to be used by the encryption mechanism for this database and select the Enable CLR Integration check box.

 If desired, we can also select the Enable automatic execution of Integration Services stored procedure at SQL Server startup check box.

When we click OK, We will see that the SSISDB catalogs is now available in the Integration Services Catalogs folder in Object Explorer.

When SSISDB created on the Integration Service Catalogs a Database in created on Database named as SSISBD.

It has several tables to manage the Package. List of tables

catalog_encryption_keys catalog_properties data_type_mapping environment_permissions environment_references environment_variables environments event_message_context event_messages executable_statistics executables execution_component_phases execution_data_statistics execution_data_taps execution_parameter_values execution_property_override_values executions extended_operation_info folder_permissions folders object_parameters object_versions operation_messages operation_os_sys_info operation_permissions operations packages project_permissions projects trace_xe_action_map trace_xe_event_map validations

The SSISDB catalog has a specific structure for organizing packages. We group individual SSIS packages into a project, and we put a group of related projects into a folder. The folder will be directly under the SSISDB catalog.