 Hello, welcome to SS Unitech, so see this side and this is continuation of SSI tutorial. So today we gonna discuss about checkpoints. So what is checkpoint and how we can use it in our package. So let's start with checkpoints. So it is used when package fails. So basically it is used to restart the package from the point of failure instead of re-running whole the package and it will start from the point of failure. And it is very useful while we are going to deal with large data like we are going to import and export images. Assume you have 100 tasks in a package and 99 tasks have been completed with success and our last task would be fail. If we are not going to configure checkpoints in our package then after correcting the error once we run our package then whole package will re-run and all the task will be re-run. If we are going to configure checkpoints in our package then our last task will be executed and 99 tasks which have been executed with success will not going to execute again. So how we can configure goto on ssgt and here I would like to add one more package then I wish to rename this package with checkpoints of that. Here I wish to add couple of executes equal task. So I am going to use three executes equal task. Then I want to configure our first. Here I need to create a connection with any database so click on OK. Here I am going to select 100 that is fine now click on OK. Connect with our second execute equal task. Here I want to create a custom error so 100 divided by 0 so it will reflect an error. Now click on OK. In our third execute equal task I want to make connection then I want to select one. So once our package will be executed then our second execute equal task will be failed. Our package will be failed at this point. So I want to use checkpoints so goto on properties of the package and here as you can see here we have checkpoint options. So first is file name so here we need to select a file name. I want to create a file at the run time with the name of checkpoint dot XML now click on open. Once our package will be failed then package information will be stored on this file. In our checkpoint usage I want to use if adjust in our save checkpoints select with true. Now we have done now we can cancel this and at the task level we need to set a property which is fail package on failure we need to select with true. In our second execute equal task again we need to select true. In our last again we need to select with true. Now we can close it now we can save it. Now I want to execute this package so first task will be executed successfully and in our second task will be failed. So click on start. So as you can see first task executed successfully. So goto on the folder. So here as you can see we are having checkpoints.xml file now we can edit in notepad plus plus so this is our checkpoint file. So it has the information of our package. Now goto on ssdt we stop this package. So once again we will execute our package then our first task will not going to execute one more time because it has been executed successfully. So our package will be executed at our second execute equal task. So let's remove the error and I want to use select5 now click on OK. So our package will be executed and it will start from second execute equal task. Now click on start. So as we can see our first execute equal task is not executed. Our last two execute equal tasks have been executed. So once package executed successfully then checkpoint file will be deleted. So as we can see we are not having file over here. Now let's stop this package. I hope you have understand how we can use the checkpoints in our package. Thank you so much for watching this video. If you like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much.