asked
SSIS Grand Child Package checkpoints
Hi , 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?? Thanks, Kannan
Hi Kannan I performed a title test which proves that checkpoints work at individual child package level. Here is the brief description of my test:- 1. Parent package has excute package task inside foreach loop container that points to child package 2. In the child package there is a data flow, with a script task before and after the data flow at control flow level 3. added script task to show pop values of different variables 4. data flow has a simple operation to get data from flat file to source 5. added a checkpoint file to the child package 6. added a erroneous value in one of the columns in flat file to implement checkpoint functionality. 7. on executing the parent package , first script task fired (inside child package and variable 1 value poped up ) then the data flow errored out 8. running the parent package again, child package started from data flow task instead of first script task
18 People are following this question.
