---
title: "catalog.operation_messages (SSISDB Database) | Microsoft Docs"
ms.custom: ""
ms.date: "03/03/2017"
ms.prod: sql
ms.prod_service: "integration-services"
ms.reviewer: ""
ms.technology: integration-services
ms.topic: "language-reference"
helpviewer_keywords: 
  - "catalog.operation_messages view [Integration Services]"
  - "operation_messages view [Integration Services]"
ms.assetid: 0b3cbe38-ce24-47ca-83ef-6538a5299d1a
author: chugugrace
ms.author: chugu
---
# catalog.operation_messages (SSISDB Database)

[!INCLUDE[ssis-appliesto](../../includes/ssis-appliesto-ssvrpluslinux-asdb-asdw-xxx.md)]


[!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)]

  Displays messages that are logged during operations in the [!INCLUDE[ssISnoversion](../../includes/ssisnoversion-md.md)] 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](../../integration-services/system-views/catalog-extended-operation-info-ssisdb-database.md) 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<br /><br /> 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.<br /><br /> 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.