We have a Master SSIS package and it calls few other child packages and some tasks,We have UI portal build for it to start the master package and to check the status of the package.Whenever package fails(i.e.because of network issues or other errors which can be rectified by user.) at particular task either in master package or in child package. User will be provided with two options Start/Resume on UI for that package. If he selects Resume, package should start from where it stopped previously. If he selects Start, package should start from the beginning.
I thought of to achieve this by using check points in ssis, but my question is what if the child package got failed. so when user selects resume the master package, it should start from failed task in child package which is being called in master package. Sometimes user may want to start from the beginning and selects start, check points should be disabled and it should start from beginning.
Try to use transactions in sequence containers of the child packages. Also enable checkpoints. So, when any error occurs the transaction will be rolled back for the container and the checkpoint will enable re-execution from a user defined location. The transaction in turn, will rollback the part which throws exception.