Checkpoints within containers - by David R. K. DeLoveh

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 269556 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 4/9/2007 6:57:49 AM
Access Restriction Public


Within SSIS checkpoints, even by their naming, are confusing.  Others have provided feedback about the properties it utilizes to decide if a task should be rerun on failure.  But I think that it is even more of an issue when using containers.  Take for instance a package with a few tasks, then a sequence container with few tasks within it, and then a few more tasks.  Assume also that all items are connected sequentially with constraints, not to run in parallel.  If a failure occurs on a task prior to or following the sequence container I could easily control if an item would be rerun.  But if it failed within the container, then I would assume I could control what will be rerun by how I configure the FailPackageOnFailure and FailParentOnFailure of the container and the tasks.  If I want to treat the tasks within the container as a set of tasks to always be rerun as a whole this is not possible.  Based on having the FailParentOnFailure property it would make sense that setting this to true could be used to fail the container.  And by not setting the FailPackageOnFailure for the tasks in the container it would not remember the completion of the tasks within.  This is obviously not how it works.  I know I can get this sort of functionality if I move the sequence container items into a subpackage with no checkpoint file.
Sign in to post a comment.
Posted by Microsoft on 7/23/2010 at 2:06 PM
Thank you for contacting us. After analyzing this issue and prioritizing it in the context of our current development plans, we have found regretfully that it does not meet the bar to be included in an upcoming product release. If you feel that you could provide us with more data to change that judgment, we welcome any further information. Your feedback continues to be invaluable to us and we take all your communication seriously. Please continue to contact us with any questions, suggestions and issues as they arise.

     The SSIS Team
Posted by Microsoft on 10/22/2007 at 4:41 PM
Thank you for your feedback; however this request is not into our current priorities. We will look at it in the future.

Thank you for your time and support.
Posted by Jamie Thomson on 7/17/2007 at 2:33 PM
Read this thread:

As you can read there is a bug with the sequence container. There is a demo of the workaround here: