I am trying to migrate the existing logic implemented in DTS package to SSIS. Currently DTS package is using ActiveX script tasks to restart the package from the point where it was stopped when there were errors and also it uses execute sql task to insert error status into DB when any of the tasks failed. I got to know that there is an option called Checkpoints using which i can restart SSIS package from the point where it got failed. But my issue is that, the task is getting stopped when it fails and do not execute the custom error task which will write the error meessage to my preferred table. I understand that the package will stop execution the moment any task fails as per the checkpoint logic. How ever, If I stick to Checkpoint usage, Is there any way to restart the package from the point where it got stopped (in case of errors) and also to use my custom error logic (to get error status in my table)? I don't want to use SSIS package's builtin error logs which will write the error details to it's own table.
Are you getting any error during the checkpoint process? http://www.mssqltips.com/tip.asp?tip=1408 fyi