Sunday 16 April 2017

List of tables in SSISDB

1.       Folders
2.       Object_versions
3.       Projects
4.       Packages
5.       Object_parameters
6.       Environments
7.       Environment_variables
8.       Environment_references
9.       Operations
10.   Extended_operation_info
11.   Operation_os_sys_info
12.   Operation_messages
13.   Executions
14.   Executables
15.   Executable_statistics
16.   Execution_data_statistics
17.   Execution_component_phases
18.   Execution_data_taps
19.   Event_messages
20.   Event_message_context
21.   Execution_parameter_values
22.   Execution_property_override_values
23.   Validations
24.   Catalog_properties
25.   Folder_permissions
26.   Project_permissions
27.   Environment_permissions
28.   Operation_permissions
29.   Data_type_mapping
30.   Catalog_encryption_keys
Posted by at
Labels: SQL SERVER, SSIS, SSAS, SSRS

1 comment:

  1. Anonymous4 May 2020 at 19:50

    Hi Sir, If we want to change the connection string for already deployed source. Where we need to modify either in ssisdb tables do we need to modify? Because in my case i have changed in all the configurations and connection manager but it taking the old value only. Could you pls help me?

    ReplyDelete

If you have any doubt, please let me know.

Subscribe to: Post Comments (Atom)

Popular Posts