O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

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: The power of restartability

Data transfer packages may transfer millions of rows every night and if one or more tasks fail during execution this may cause the package to fail. If we re-run a failed package then it will start from the first executable object in control flow, and this will be a problem because maybe a Data Flow Task which transferred 10 million records last night re-executed and got a lot of resource again; that doesn't sound worthy.

SSIS packages can be restartable, they can store the status of execution and start execution from the previous status, these are all supported by checkpoints. One of the most understandable definitions for checkpoint can be found in video games; Checkpoint will save the status of the game, ...

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