title: ODI - COPY DATA FROM ONE DATA SOURCE TO ANOTHER WITH PROCEDURE
body: <p>I have trying to create a procedure that will copy data from one data source to another with the use of a procedure.</p>
  
  <p>I am not using mapping because in a later stage the table name will be populated in a parameter table.</p>
  
  <p>I have tried to put below SQL in Source Command</p>
  
  <p>Select * from table_a --From Data Source 1</p>
  
  <p>and below in Target Command</p>
  
  <p>Insert into table_b  --From Data Source 2</p>
  
  <p>I know there is something missing in the target command but haven't been able to come across any source that can help.</p>
  
  <p>thanks &amp; regards</p>