title: SSIS Package. Checking if tables exist, if not create if they do Truncate
body: <p>I am brand new to SSIS and I have to create a SSIS package to migrate data from one database to another. I want to start off the package by checking if a number of tables exist in the destination database. If they do exist I want to truncate them if they don't I want to create them. Whats the best approach to doing this. </p>
  
  <p>I have a simple query at the very top of the package to return all tables in the destination database</p>
  
  <pre><code>SELECT TABLE_NAME 
  FROM INFORMATION_SCHEMA.TABLES
  WHERE TABLE_TYPE = 'BASE TABLE'
  </code></pre>
  
  <p>How do I pass these results to the next step to check if any of these table names are contained within a list or array of table names</p>
  
  <p>Thanks </p>