title: Best way of updating a table with SSIS using a OLE DB Command
body: <p>I have the next query</p>
  
  <pre><code>insert into tabla_A (value_1, value_2, value_3)
  select table_B.value_1, table_B.value_2, table_B.value_3
  from tabla_A right join (table_C left join table_D on table_C.value1 = table_D.value1)
  on table_A.value_1 = table_B.value_1
  where table_A is null
  </code></pre>
  
  <p>As you can see, I have several tables involved in this query, and the thing is that table_B, table_C, table_D belong to an Oracle Database and Table_A is located in a SQL server.</p>
  
  <p>What do you thing is the best way to face this query?, I mean by using the less quantity of merge join tasks, and using more the SQL statement. Also taking into account that source and destination are the same (table_A)</p>