Export (0) Print
Expand All

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.

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.

NoteNote

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.

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 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.

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Community Additions

ADD
Show:
© 2014 Microsoft