title: Truncate table in SSIS
body: <p>I have a simple data flow in <code>SSIS</code> (defined in visual studio 2013), which uses SQL to extract data from one sql server instance's table A to then add it to another SQL server instance's table B. </p>
  
  <p>What is the best practice pattern to truncate the data in table B? A truncate statement like this:</p>
  
  <pre><code>TRUNCATE TABLE B
  </code></pre>
  
  <p>after the select statement for table A - especially when you have have a fairly big table to 'transmit'? </p>