Package “” failed.

Details
Product: SQL Server
Event ID: 12291
Source: SQLISPackage100
Version: 10.0
Component: Integration Services
Symbolic Name: DTS_MSG_PACKAGEFAILURE
Message: Package “” failed.
   
Explanation

The specified Integration Services package was unable to finish running and has stopped.

Possible Causes

There are many possible causes for a package to stop running. This message might appear because of one of the following problems:

  • The data sources, files, or credentials that were specified on the development computer are not available or are not valid on the computer on which the package was deployed.

  • Data providers that were available on the development computer are not available on the computer on which the package was deployed. Or, data providers that were available in 32-bit versions are not available when the package is run as a 64-bit package.

  • The permissions that are required by the package are not sufficient when the package is scheduled in a SQL Server Agent job.

   
User Action

Depending on whether the error that caused the package to stop running 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 that caused the package to stop running is expected to occur occasionally, try one of the following options:

    • Consider using an error handler to handle the error. For more information, see Integration Services Event Handlers.

    • Consider using checkpoints to restart the package from a specific point. For more information, see Using Checkpoints in Packages.

    • Consider using transactions to ensure the integrity of your data. For more information, see Incorporating Transactions in Packages.

Related:

Leave a Reply