Events Logged by an Integration Services Package

 

Applies To: SQL Server 2016

An Integration Services package logs various event messages to the Windows Application event log. A package logs these messages when the package starts, when the package stops, and when certain problems occur.

This topic provides information about the common event messages that a package logs to the Application event log. By default, a package logs some of these messages even if you have not enabled logging on the package. However, there are other messages that the package will log only if you have enabled logging on the package. Regardless of whether the package logs these messages by default or because logging has been enabled, the Event Source for the messages is SQLISPackage.

For general information about how to run SSIS packages, see Execution of Projects and Packages.

For information about how to troubleshoot running packages, see Troubleshooting Tools for Package Execution.

When you run an Integration Services package, the package typically logs various messages about the progress and status of the package. The following table lists those messages.

System_CAPS_ICON_note.jpg Note


The package will log the messages in the following table even if you have not enabled logging for the package.

Event IDSymbolic NameTextNotes
12288DTS_MSG_PACKAGESTARTPackage "" started.The package has started to run.
12289DTS_MSG_PACKAGESUCCESSPackage "" finished successfully.The package successfully ran and is no longer running.
12290DTS_MSG_PACKAGECANCELPackage "%1!s!" has been cancelled.The package is no longer running because the package was canceled.
12291DTS_MSG_PACKAGEFAILUREPackage "" failed.The package could not run successfully and stopped running.

By default, in a new installation, Integration Services is configured not to log certain events that are related to the running of packages to the Application event log. This setting prevents too many event log entries when you use the Data Collector feature of the current release of SQL ServerIntegration Services. The events that are not logged are EventID 12288, "Package started," and EventID 12289, "Package finished successfully." To log these events to the Application event log, open the registry for editing. Then in the registry, locate the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\SSIS node, and change the DWORD value of the LogPackageExecutionToEventLog setting from 0 to 1. However, in an upgrade insallation, Integration Services is configured to log these two events. To disable logging, change the value of the LogPackageExecutionToEventLog setting from 1 to 0.

If you have enabled logging on the package, the Application event log is one of the destinations that is supported by the optional logging features in Integration Services packages. For more information, see Integration Services (SSIS) Logging.

When you have enabled logging on the package and the log location is the Application event log, the package logs entries that pertain to the following information:

  • Messages about which stage the package is in while the package runs.

  • Messages about particular events that occur while the package runs.

Messages about the Stages of Package Execution

Event IDSymbolic NameTextNotes
12544DTS_MSG_EVENTLOGENTRYEvent Name: %1%r Message: %9%r Operator: %2%r Source Name: %3%r Source ID: %4%r Execution ID: %5%r Start Time: %6%r End Time: %7%r Data Code: %8When you configure package logging to the Application event log, various messages use this generic format.
12556DTS_MSG_EVENTLOGENTRY_PACKAGESTARTEvent Name: %1%r Message: %9%r Operator: %2%r Source Name: %3%r Source ID: %4%r Execution ID: %5%r Start Time: %6%r End Time: %7%r Data Code: %8The package started.
12547DTS_MSG_EVENTLOGENTRY_PREVALIDATEEvent Name: %1%r Message: %9%r Operator: %2%r Source Name: %3%r Source ID: %4%r Execution ID: %5%r Start Time: %6%r End Time: %7%r Data Code: %8Validation of the object is about to begin.
12548DTS_MSG_EVENTLOGENTRY_POSTVALIDATEEvent Name: %1%r Message: %9%r Operator: %2%r Source Name: %3%r Source ID: %4%r Execution ID: %5%r Start Time: %6%r End Time: %7%r Data Code: %8Validation of the object has finished.
12552DTS_MSG_EVENTLOGENTRY_PROGRESSEvent Name: %1%r Message: %9%r Operator: %2%r Source Name: %3%r Source ID: %4%r Execution ID: %5%r Start Time: %6%r End Time: %7%r Data Code: %8This generic message reports package progress.
12546DTS_MSG_EVENTLOGENTRY_POSTEXECUTEEvent Name: %1%r Message: %9%r Operator: %2%r Source Name: %3%r Source ID: %4%r Execution ID: %5%r Start Time: %6%r End Time: %7%r Data Code: %8The object has finished its work.
12557DTS_MSG_EVENTLOGENTRY_PACKAGEENDEvent Name: %1%r Message: %9%r Operator: %2%r Source Name: %3%r Source ID: %4%r Execution ID: %5%r Start Time: %6%r End Time: %7%r Data Code: %8The package has finished running.

Messages about Events that Occur

The following table lists only some of the messages that are the result of events. For a more comprehensive list of error, warning, and informational messages that Integration Services uses, see Integration Services Error and Message Reference.

Event IDSymbolic NameTextNotes
12251DTS_MSG_EVENTLOGENTRY_TASKFAILEDEvent Name: %1%r Message: %9%r Operator: %2%r Source Name: %3%r Source ID: %4%r Execution ID: %5%r Start Time: %6%r End Time: %7%r Data Code: %8The task failed.
12250DTS_MSG_EVENTLOGENTRY_ERROREvent Name: %1%r Message: %9%r Operator: %2%r Source Name: %3%r Source ID: %4%r Execution ID: %5%r Start Time: %6%r End Time: %7%r Data Code: %8This message reports an error that has occurred.
12249DTS_MSG_EVENTLOGENTRY_WARNINGEvent Name: %1%r Message: %9%r Operator: %2%r Source Name: %3%r Source ID: %4%r Execution ID: %5%r Start Time: %6%r End Time: %7%r Data Code: %8This message reports a warning that has occurred.
12258DTS_MSG_EVENTLOGENTRY_INFORMATIONEvent Name: %1%r Message: %9%r Operator: %2%r Source Name: %3%r Source ID: %4%r Execution ID: %5%r Start Time: %6%r End Time: %7%r Data Code: %8This message reports informational that is not associated with an error or a warning.

For information about how to view log entries in real time, see View Log Entries in the Log Events Window.

Events Logged by the Integration Services Service

Community Additions

ADD
Show: