Checkpoints and Transactions

SSIS package checkpoints are a type of optional save point that allows a package to be restarted from a point of failure. We have used checkpoints with SSIS packages that may include occasional failures resulting from (for example) a component that connects to a public Web service to retrieve data from the Internet. A checkpoint is literally an XML file that contains information about which components ran successfully at a particular execution date and time. You can configure checkpoints at the package level only. Checkpoints are often used in conjunction with transactions. We’ll get into more detail about configuring package transactions shortly.

The key properties available for packages that are associated with checkpoint ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.