catalog.operation_messages (SSISDB Database)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Displays messages that are logged during operations in the Integration Services catalog.

Column name Data type Description
operation_message_id bigint The unique identifier (ID) of the message.
operation_id bigint The unique ID of the operation.
message_time datetimeoffset(7) The time when the message was created.
message_type smallint The type of message displayed.
message_source_type smallint The ID of the type of message source.
message nvarchar(max) The text of the message.
extended_info_id bigint The ID of additional information that relates to the operation message, found in the extended_operation_info view.

Remarks

This view displays a row for each message that is logged during an operation in the catalog. The message can be generated by the server, by the package execution process, or by the execution engine.

This view displays the following message types:

message_type Value Description
-1 Unknown
120 Error
110 Warning
70 Information
10 Pre-validate
20 Post-validate
30 Pre-execute
40 Post-execute
60 Progress
50 StatusChange
100 QueryCancel
130 TaskFailed
90 Diagnostic
200 Custom
140 DiagnosticEx

Whenever an Execute Package task executes a child package, it logs this event. The event message consists of the parameter values passed to child packages.

The value of the message column for DiagnosticEx is XML text.
400 NonDiagnostic
80 VariableValueChanged

This view displays the following message source types.

message_source_type Description
10 Entry APIs, such as T-SQL and CLR Stored procedures
20 External process used to run package (ISServerExec.exe)
30 Package-level objects
40 Control Flow tasks
50 Control Flow containers
60 Data Flow task

Permissions

This view requires one of the following permissions:

  • READ permission on the operation

  • Membership to the ssis_admin database role

  • Membership to the sysadmin server role

Note

When you have permission to perform an operation on the server, you also have permission to view information about the operation. Row-level security is enforced; only rows that you have permission to view are displayed.