Pro Programmer: Checkpoint and Breakpoint

Tuesday, August 14, 2012

Checkpoint and Breakpoint

Checkpoint: Ensures that if your package fails after  multiple tasks have succeeded, the progress you made will not be lost. A checkpoint will save all of the information prior to that task failing. You can run the package from that checkpoint and not have to start over.


Breakpoint: A stopping point in the code that gives you the chance to review the status of the data, variables, and overall status of the ssis package.

No comments:

Post a Comment