So the potential for data loss, would exist anywhere between steps 1 and 5 as shown in your diagram.

Since the transaction is not committed on the PRINCIPAL, there is "real...

Thank you for taking the time to clear my confusion 🙂

Thanks for your reply ,

Maybe my understanding is wrong here

I was under the impression , that the transaction would be committed on the principal only after it has...

Thank you for this post, it helped me understand how the for each loop container writes into a variable , which is then subsequently used in the connection manager.

Can you shed some light on why the transaction log was huge in the first place ?

Also wont it grow back to its original size once the effects of the...