I am thinking that SSIS DTC does not really work or that there are some special attributes
that tasks contained in a sequence with transaction=required, that these tasks need to
have. Is sequentiality and same-thread guaranteed for all tasks in a sequence? I'm getting
failures on the first task in a transactioned sequence for no reason, am tempted to bag
SSIS/DTC and go with the literal BEGIN TRANSACTION ( which would involve redesigning
the whole loop -- arrgghh )