Understanding Events Logged by an Integration Services Package
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 Integration Services packages, see Running Packages.
For information about how to troubleshoot running packages, see Troubleshooting 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 SQL Server 2008. 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\100\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.
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 Logging Package Execution.
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 SSIS 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. |
|