O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required