SQLISPackage_12551
Details
Product Name |
SQL Server |
Product Version |
10.0 |
Product Build Number |
|
Event ID |
12551 |
Event Source |
SQLISPackage100 |
Component |
Integration Services |
Symbolic Name |
DTS_MSG_EVENTLOGENTRY_TASKFAILED |
Message Text |
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 |
Explanation
A task in an Integration Services package did not finish its work and stopped.
Possible Causes
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 a task in the package did not finish its work and stopped. There are many possible reasons for which a task might stop.
User Action
Depending on whether it is unexpected to have the task stop running, you might have to take one of the following steps:
If it is unexpected to have the task stop running, 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 task to fail. For a list of troubleshooting suggestions, see Troubleshooting Package Execution.
If it is expected that the task will occasionally stop running, 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 task 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.