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

more ▼

asked Oct 29, 2015 at 02:34 PM in Default

avatar image

2.8k 56 65 71

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

more ▼

answered Oct 29, 2015 at 06:36 PM

avatar image

2k 4 12 16

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 29, 2015 at 02:34 PM

Seen: 139 times

Last Updated: Oct 29, 2015 at 06:36 PM

Copyright 2018 Redgate Software. Privacy Policy