Product Build Number
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
An error message was raised in an Integration Services package.
This log entry appears in the event log because logging is enabled in the package, and the Windows event log was selected as the destination for logging. The Windows event log is one of the destinations that are supported by the optional logging features in Integration Services packages. For more information, see Logging Package Execution.
This log entry appears because an error message was raised in the package. There are many possible reasons for an error message.
For a list of error, warning, and informational messages that are used by Integration Services, see SSIS Error and Message Reference.
Depending on whether the error is unexpected, you might have to take one of the following steps:
If the error is unexpected, review the troubleshooting suggestions for Integration Services packages. These suggestions include the use of logging and of debug dump files to learn more about what is causing the package to fail. For a list of troubleshooting suggestions, see Troubleshooting Package Execution.
If the error indicates a problem that is expected to occur occasionally, try one of the following options:
Consider using an event handler to handle the problem. For more information, see Integration Services Event Handlers.
Consider using checkpoints to restart the package from a specific point if the package stops running. For more information, see Restarting Failed Packages by Using Checkpoints.
Consider using transactions to ensure the integrity of your data. For more information, see Ensuring Data Integrity by Using Transactions.