title: handled dynamically missing source columns in ssis
body: <p>I have a small SSIS question. I'm extracting data from a MySQL table with a varying column list to a SQL Server table with a fixed column list.</p>
  
  <p>source table:  Test(mysql server)</p>
  
  <pre><code> id  |     name   |    sal      | deptno | loc     |   referby
   1   |      abc   |     100     |10      | hyd     |    xyz
   2   |      mnc   |     200     |20      |chen     |    pqr   
  </code></pre>
  
  <p>First I select MySQL table configuration, then I drag and drop oledbdestination for MySQL server table configuration. I configure the target table, and after that the package works fine and the data looks like below.</p>
  
  <p>Target table :  Test (sql server )</p>
  
  <pre><code>id   |     name   |     sal     |deptno        | loc           |referby
   1   |      abc   |     100     |10            | hyd           |    xyz
   2   |      mnc   |     200     |20            |chen           |    pqr  
  </code></pre>
  
  <p>The second time I run the package, a column has been removed from the source table's schema, so the package fails. I open the MySql server testsource configuration and I edit the query to return NULL for the missing column:</p>
  
  <pre><code> select id,'null' as name,sal,deptno,loc,referby from test
  </code></pre>
  
  <p>I rerun the package and the data looks like this.</p>
  
  <p>Target table :  Test (sql server )</p>
  
  <pre><code>id   |     name   |     sal     |deptno        | loc           |referby
   1   |      null  |     100     |10            | hyd           |    xyz
   2   |      null  |     200     |20            |chen           |    pqr  
  </code></pre>
  
  <p>I always truncate the target table and load data. </p>
  
  <p>The target table has an unchanging list of columns while the source table's column list can vary. <strong>I do not want keep editing the query to account for possible missing columns.</strong> How I can handle this at the package level?</p>