I have a Master Package which executes a child package for each client. This is driven by the master table which has the list of clients that needs to be loaded. The child package in turn executes another child package ( grand child package to load the data to many tables). Once when the child package is complete it will update the master table that the client is loaded, so next time of execution the client will not be picked up.
Now when there is a failure in one of my data flow tasks in the grand child package , I want the grand child package to start from that task. basically I want to enable check point at my grandchild package level.
I have heard the for each loop doesn't support check points? Will enabling check points at my grand child package which is with in a foreach loop in the master package work??
I performed a title test which proves that checkpoints work at individual child package level. Here is the brief description of my test:-