Event Messages table in SSISDB

This table stores the message information which is logged during the package execution.

SELECT [event_message_id]       ,[operation_id]       ,[execution_path]       ,[package_name]       ,[package_location_type]       ,[package_path_full]       ,[event_name]       ,[message_source_name]       ,[message_source_id]       ,[subcomponent_name]       ,[package_path]       ,[threadID]       ,[message_code]   FROM [SSISDB].[internal].[event_messages]