The specified Integration Services package was unable to finish running and has stopped.
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.
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 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.