Designing Packages for Reliability
This section describes the Integration Services features that enable you to handle errors, restart failed packages, and ensure data integrity.
In This Section
Handling Errors in the Data Flow
Describes the common data flow errors and how to use the error output to handle row-level errors.Ensuring Data Integrity by Using Transactions
Describes how to use transactions in a package to ensure data integrity and manage rollback.Restarting Failed Packages by Using Checkpoints
Describes checkpoints, and how to implement checkpoints in a package to make it restartable.