title: SSIS Multiple Table Inserts vs. Union ALL
body: <p>I am new to SSIS and I am writing my first SSIS package.</p>
  
  <p>In my package, in the data flow there are several stages of transformation and for each stage a script component is inserting records (some sort of custom Log) to a ADO.NET destination.</p>
  
  <p>I am using multiple ADO.NET Destination component that is pointing to the same table in the same database.</p>
  
  <p>I wonder if this is a correct approach or if I should use Union ALL and insert all records at once.</p>
  
  <p>Any help would be appreciated.</p>