Checkpoints in SSIS :

This post will help you who are learning bi.The usage of Checkpoints is when you create a big package
it will take execution time nearly 1hr time suddenly some error throws.then what next find the error where it is occurred and Fix it.this normal behaviour in this way it starts from starting of the package.
this Probelm overcome to introduce Checkpoints in ssis.the aim of this is while execution time Error occurred at certain task failed then Fix the Error and start execution from where error is occurred.

checkpoints means to start from last failure point of the Package.

see the below example

1.we have create a table in the database (Empty).

create table CheckPoints(ID INT  primary key ,Name Varchar(10))

2.I have taken three Execute sql tasks For insert the data into the table.

3.right click on controlflow ->goto->Properties.

4.Configure the above properties.
5.and  press F4 on every task .and true the property FailPackageonFailure.

6.if we run tha package fail bacause every  Sqltask have below query.

 insert into CheckPoints values(1,'x') 

 so because Primary key violation error.

 when you change the query in 2nd Sqltask 

 insert into Checkpoints values(2,'y') 

 then start from 2nd Sqltask .like it will Executed.