Hi guys -
I've been working in ssis for a bit but never have encountered the need for transactions - until I realized that I really need them. Here's my setup.
I have a master package that has a sequence container in it. In that sequence container are 3 execute package tasks (Insert - Update - Delete). Each execute package task points to a child package which contains 50 execute package tasks (to perform the tasks
on my different tables). From there - the actual work is done. (default everything on transaction/isolation etc)
My problem/question is that I need to make it where if the insert fails, the update/delete do not happen and everything gets rolled back. Right now if something fails it just stops there and gives me half changed records.
Is there a way to do this or am I just hoping for un-doable?
View Complete Post