Hello!

I went and developed a simple package, to make sure how exactly check points and transcations work with each other.

Have one container1 ( task1(required), task2(required), task3(required) )on SSIS designer ( Supported). This works fine and I can understand whats its doing, if anything inside this container fails, it rollsback and executes from the begining.

My question, if I add another task AB(script task) to designer which should executes after the container1. And when AB(task) is made to fail forcefully, now when i go for executing, my package starts from the begining i.e container1 { as I except it to begin from the task(AB) }.

I am confused with the checkpoints and transcations, can I enable both transcations and checkpoints on a package.

If Yes is the answer then, why is it, my package starts picking (executing from the container again). And one more thing I observed, when I want my transcationoption on packagescope to required, it doesn't allow. Inreturn, it asks me to disable the check point. I disabled check points and then it allows me to chage the packagescope to reuired now, but there is no check point on my package. I am very sorry...if the things I mentioned are very basic to get. But that itself is not clear and I couldn't get much out of the books and Onlinebooks ....plz consider to help me here. Hoping that you through some more knowledge,Thank you ...plz do ping, if anything i mentioned here is not clear..Thank you

Submitted under: Microsoft SQL Server · SSIS - SQL Server Integration Services · TRANSACTIONS ·  ·