title: ETL as a transaction
body: <p>For all the ETLs I have written so far, I have never made them transactions - i.e. if table 4 fails, roll everything back.</p>
  
  <p>What is the best practice in this regard?</p>
  
  <p>To "BeginTran + Commit" or not to "BeginTran + Commit"</p>
  
  <p>EDIT: I have one master package calling 4 other packages - is it possible to roll them all up into one transaction?</p>