title: Execute SQL Task with multiple stored procedures with input and out parameter
body: <p>I have an "Execute SQL Task" with ONE stored procedure which needs to be called multiple times.</p>
  
  <p>This stored procedure takes one input value and returns one output value.</p>
  
  <p>So my code is like :  </p>
  
  <pre><code>EXEC test.sp_workdone ?,'TableName'  
  EXEC test.sp_workdone ?,'TableName1'  
  EXEC test.sp_workdone ?,'TableName2'   
  </code></pre>
  
  <p>Where table name is different and "?" is same parameter that I need to pass. Also output is also one parameter which will be same for every result.  </p>
  
  <p>What I want to achieve here is to insert the value into a table and input value and out value which will be same one at given execution.  </p>
  
  <p>For example, <code>Audit_Table</code>: 1st execution  </p>
  
  <pre><code>1, Table, X  
  1, Table2,X  
  1, Table3,X
  </code></pre>
  
  <p><code>Audit_Table</code>: 2nd execution  </p>
  
  <pre><code>2, Table, X1  
  2, Table2,X1  
  2, Table3,X1  
  </code></pre>