title: How to drop and recreate table in destination server?
body: <p>Here is the scenario for which Iam trying to create a SSIS package using VS2013. We have SQLServer2014 servers - A &amp; B.</p>
  
  <p>From ServerA.Database1, need to copy data for few specific tables to ServerB.Database2.</p>
  
  <p>But before copy, have to drop the table and recreate the table at destination (ServerB.Database2) using the table schema from source (ServerA.Database1) because of schema changes happening frequently. Need to schedule this weekly.</p>
  
  <p>How to accomplish using SSIS (how to retrieve source table schema information in the ssis package so that it will be used to create a table at the destination) ? or any other way ?</p>
  
  <p>Thanks</p>
  
  <p>Bhanu.</p>