Hi, I have a package with 3 parallel data flow tasks added in a sequence container. I need to implement transaction such that, the transaction completes if all the 3 DFTs successfully executes. If any of the DFt fails, then transaction should rollback. How do i achieve this?
and iam traing this packagge but its not working.first i taken one seqlence container and drag and drop dft ,dft1,dft3 and i confifure dft1 and dft2 and dft3 .then in sequencee container property i put opption transaction=suported and isolation=readcomited. and remainng dft and dft2 and dft3 iproperties i put opption transaction=suported and isolation=readuncomited then after i execute package .actualy dft1 data incorrectly.that time i execute package then firest dft is fail and remains successfuly load to the destination..but i donto want load if any one fail plese give some suggestions. how to i acchive this.
Submitted under: Microsoft SQL Server · SSIS - SQL Server Integration Services · · ·
you should be setting transaction property = required for the sequence container so that any dft fails it will cause whole transaction inside sequence container to be rolledback. I hope this is what you're looking at.
what ever u say i follow but its not working suppose all are good records that time also its not working.
why? is it throwing some error?
ya its given errors
can you post error message?