Udostępnij za pośrednictwem


catalog.operation_messages (SSISDB Database)

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.

Uwagi

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

[!UWAGA]

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.