Sunday 16 April 2017

Event Messages Context table in SSISDB

This table stores the information such as package path source name, Property name and property value.
SELECT [context_id]
      ,[operation_id]
      ,[event_message_id]
      ,[context_depth]
      ,[package_path]
      ,[context_type]
      ,[context_source_name]
      ,[context_source_id]
      ,[property_name]
      ,[property_value]
  FROM [SSISDB].[internal].[event_message_context]

 



No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts