Placing Checkpoints
Checkpointing refers to placing a marker, or checkpoint, in the control flow so that, if a package fails, you can restart the package from the point of failure. Execution information is saved into a checkpoint file. Figure 9–25 shows this property option. If you choose to use checkpointing in SSIS packages, you'll want to include this capability in the initial package design of all affected packages.
Figure 9–25. To enable checkpointing in a package, you must set the CheckpointUsage property to either IfExists or Always and then set three other properties.
To implement checkpointing in your SSIS package, you must configure ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
