MSBI # 66 – SSIS # 27 – SSIS Properties #1 – Check Points Introduction and Usage

Hi folks

In the current world where we are always dealing with time , we must always utilize check points whenever we can utilize it .

In this article we are covering following points

  • Where I can find Check points option ?
  • Check points option
  • Properties for Checkpoints
  • Checkpoint Usage

We use checkpoints for tracing back and continuing flow / execution like in the game we always have checkpoints option so rework should be less . 

imageimageimage

There is lot post available for same in web @ various blog , I just thought to give my reader every points that they found relevant and not to have lot of to n fro form various website , also my idea is to share complete knowledge on one web blog.

Where I can find Check points option

Right Click and select Prop ties on SSIS plane as shown

image

On the top most section on property tab we will find checkpoint option

image

Check points option

image

Now we are good to go for configuration of check points .

Properties for Checkpoints

The checkpoint file includes the execution results of all completed containers, the current values of system and user-defined variables, and package configuration information.

The file also includes the unique identifier of the package.

To successfully restart a package, the package identifier in the checkpoint file and the package must match; otherwise the restart fails.

This prevents a package from using a checkpoint file written by a different package version.

If the package runs successfully, after it is restarted the checkpoint file is deleted.

The following table lists the package properties that we can set to implement checkpoints.

image

Additionally, we can set the FailPackageOnFailure  property to true for all the containers in the package that we want to identify as restart points.

We can also use the ForceExecutionResult property to test the use of checkpoints in a package. By setting ForceExecutionResult of a task or container to Failure, we can imitate real-time failure. When you rerun the package, the failed task and containers will be rerun.

Checkpoint Usage

The CheckpointUsage property can be set to the following values:

image

We will have lots of information in upcoming post

Hope this helps !!

Hope you have understood Introduction to check points and how to use same .

If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog

If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog

Where todays links are

Dactylonomy of Web Resource

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: