Disable Then Rebuild Non-Clustered Indexes Around a Dataflow
Queries sys.indexes for a target table, captures DISABLE and REBUILD ALTER INDEX statements into an object variable, then uses ForEachAdoLoop containers to disable every non-clustered index before a dataflow and rebuild them afterwards for faster bulk loads.