Hi

MSDTC service is running and I have kept the transaction option required however it gets hang when I run the package. with supported it runs fine. can you please help...

Hi

still its giving the following error in some cases of rollback

The Begin statement for the Rollback is not given.

Thanks & Regards,

Avadhut Joshi

hmmmmmmmm

I have set transaction option as supported for all.

I am not able to get through what is exactly happening in case of those two containers as they are un touched..ok...

if I do it then only 75% of my containers run properly last two containers dont get run..so is there any issue with that..am I doing any mistake or need...

Hi

yes its showing the control flow..

I do have

1. one execute sql task for begin transaction

2. then one for delete table

then rollback for delete

3. next data flow task

4....