title: SSIS update oracle table
body: <p>I have a SSIS package that performs an update to a Oracle table. I'm using a Data Flow task with a SQL Server OLE DB Source and a OLEDB Command to execute the update.</p>
  
  <p><img src="https://i.stack.imgur.com/x8omq.png" alt="Dataflow Task"></p>
  
  <p>The update command being executed is:</p>
  
  <pre><code>UPDATE NB_STG_APROV_WEB 
  SET stock_comm = ? 
  WHERE sku = ? AND data_info = trunc(sysdate - 1)
  </code></pre>
  
  <p>Both parameters are mapped. The package executes with success but the table is not updated. Any ideas why?</p>