Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.