I have a ssis package which have more than 10 tasks. I maintain sql table as success or failure for each task. I need to design my pkg in such a way when It fails and we run it next time, It should check the sql table and pick the task which got failed and It should execute from the failed task, But not from starting.
I do not want to use checkpoint. How can we do this?
Thanks in advance.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)