Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Designing Packages for Reliability

SQL Server 2008 R2

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft