Events Logged by an Integration Services Package
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
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.
Messages about the Status of the Package
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.
Note
The package will log the messages in the following table even if you have not enabled logging for the package.
| Event ID | Symbolic Name | Text | Notes |
|---|---|---|---|
| 12288 | DTS_MSG_PACKAGESTART | Package "" started. | The package has started to run. |
| 12289 | DTS_MSG_PACKAGESUCCESS | Package "" finished successfully. | The package successfully ran and is no longer running. |
| 12290 | DTS_MSG_PACKAGECANCEL | Package "%1!s!" has been cancelled. | The package is no longer running because the package was canceled. |
| 12291 | DTS_MSG_PACKAGEFAILURE | Package "" 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 Server Integration 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 installation, Integration Services is configured to log these two events. To disable logging, change the value of the LogPackageExecutionToEventLog setting from 1 to 0.
Messages Associated with Package Logging
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 ID | Symbolic Name | Text | Notes |
|---|---|---|---|
| 12544 | DTS_MSG_EVENTLOGENTRY | Event 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: %8 | When you configure package logging to the Application event log, various messages use this generic format. |
| 12556 | DTS_MSG_EVENTLOGENTRY_PACKAGESTART | Event 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: %8 | The package started. |
| 12547 | DTS_MSG_EVENTLOGENTRY_PREVALIDATE | Event 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: %8 | Validation of the object is about to begin. |
| 12548 | DTS_MSG_EVENTLOGENTRY_POSTVALIDATE | Event 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: %8 | Validation of the object has finished. |
| 12552 | DTS_MSG_EVENTLOGENTRY_PROGRESS | Event 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: %8 | This generic message reports package progress. |
| 12546 | DTS_MSG_EVENTLOGENTRY_POSTEXECUTE | Event 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: %8 | The object has finished its work. |
| 12557 | DTS_MSG_EVENTLOGENTRY_PACKAGEEND | Event 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: %8 | The 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 ID | Symbolic Name | Text | Notes |
|---|---|---|---|
| 12251 | DTS_MSG_EVENTLOGENTRY_TASKFAILED | Event 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: %8 | The task failed. |
| 12250 | DTS_MSG_EVENTLOGENTRY_ERROR | Event 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: %8 | This message reports an error that has occurred. |
| 12249 | DTS_MSG_EVENTLOGENTRY_WARNING | Event 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: %8 | This message reports a warning that has occurred. |
| 12258 | DTS_MSG_EVENTLOGENTRY_INFORMATION | Event 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: %8 | This message reports informational that is not associated with an error or a warning. |
View Log Entries in the Log Events Window
This procedure describes how to run a package and view the log entries it writes. You can view the log entries in real time. The log entries that are written to the Log Events window can also be copied and saved for further analysis.
It is not necessary to write the log entries to a log to write the entries to the Log Events window.
To view log entries
In SQL Server Data Tools, open the Integration Services project that contains the package you want.
On the SSIS menu, click Log Events. You can optionally display the Log Events window by mapping the View.LogEvents command to a key combination of your choosing on the Keyboard page of the Options dialog box.
On the Debug menu, click Start Debugging.
As the runtime encounters the events and custom messages that are enabled for logging, log entries for each event or message are written to the Log Events window.
On the Debug menu, click Stop Debugging.
The log entries remain available in the Log Events window until you rerun the package, run a different package, or close SQL Server Data Tools.
View the log entries in the Log Events window.
Optionally, click the log entries to copy, right-click, and then click Copy.
Optionally, double-click a log entry, and in the Log Entry dialog box, view the details for a single log entry.
In the Log Entry dialog box, click the up and down arrows to display the previous or next log entry, and click the copy icon to copy the log entry.
Open a text editor, paste, and then save the log entry to a text file.