title: How to merge two tables in ssis
body: <p>I have two tables in one database
  customer table have customer coordinate infos
  Customer type have infos about the type of customer</p>
  
  <p>I want to have a destination table that has </p>
  
  <pre><code>destination customer table
  key
  name
  adress
  ...
  type
  </code></pre>
  
  <p>I did create a database vue of customer table + customer type but the result query only showed me the fields that have customer table key=customer table foreign key in customer type</p>
  
  <p>and there are also fields in customer table that have no type.
  How do I solve this issue   </p>