Click here to Skip to main content
15,070,974 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi All, 

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.


What I have tried:

I am thinking to disable the tasks as soon as we finish it, but that is complicated it seems.
Posted
Comments
Gerry Schmitz 9-Jun-21 0:02am
   
I expect restarting on the failed step without doing anything else will result in the same step failing. Even a checkpoint wouldn't help.
jaiswal Preeti 9-Jun-21 1:18am
   
@gerry Schmitz: Then How we can achieve this?
Gerry Schmitz 9-Jun-21 11:35am
   
Someone fixes the problem and insures the same problem doesn't happen again.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900