title: SSIS - Updating a table with a OLE DB Command
body: <p>I need to translate the next SQL Query in SSIS: (Each table belong to a different source - SQL Server &amp; ORACLE)</p>
  
  <pre><code>update A
  set
  A.col1 = B.col1
  A.col2 = B.col1
  from
  table A inner join table B B on A.col3 = Col3
  where
  A.col4 = value 1 and
  A.col5 = value2 and
  B.col4 = value 3;
  </code></pre>
  
  <p>As you can see, source and destination corresponds to the same source: table A. This is the work flow I have created.</p>
  
  <p><img src="https://i.stack.imgur.com/2p81n.jpg" alt="enter image description here"></p>
  
  <p>After the conditional split I have used a Derived Column in order to copy the column B.Col1 to use it on the OLE DB Command to update the columns of table A
  After that, I have write the next piece of query in the OLE DB Command task:</p>
  
  <pre><code>update Table A
  set
  col1 = ?
  col2 = ?
  </code></pre>
  
  <p>But at this point I have a question, Am I updating only the values of the subset that I got from the conditional split, or am I updating all table A. Besides, the last part of the updating query makes reference to table B and in the OLE DB Command task I can make reference to only one source of data.</p>
  
  <p><strong>clarifications:</strong>
  The code is just a schema, so I do not need correction about it, that is not my doubt (in case I have made a mistake).</p>
  
  <p>I was asked to make this translation without modifying the sql query.</p>
  
  <p>If you need to know more to give help, please ask, but be polite.</p>
  
  <p>Regards</p>