Availability Groups

• Snapshot isolation transaction failed in database (Availability Group and SSIS woes)

  Apr 5, 2018

  The Setup:

  I have a SSIS package and it runs a relatively basic ETL setup. We take data from TableA, move it to TableB. TableB is a heap, we index it in our ETL and drop it afterwards. Now we join TableB to TableC. The reason we don’t go from A to C is because of the data relationship, it can cause a cascade join that creates BILLIONS of reads when we plug in some where predicate values.