Designing Packages for Reliability

This section describes the Integration Services features that enable you to handle errors, restart failed packages, and ensure data integrity.

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.

Community Additions