title: Record rows updated through SSIS execute task
body: <p>I have a package which connects to <code>SourceDB1</code> and execute an update statement that updates DestDB2. Now I have many such source DB and destination DB which has the similar structure.  For this I have for each loop container within which the execute SQL task is placed. Now, since the sourceDB connection varies , I have created a variable named <code>SourceConnString</code>. Likewise, the update query is also within a variable named <code>UpdateVariable</code>. I created <code>UpdateVariable</code> because source and destination are two different databases. </p>
  
  <p>Now I need to save the number of records that are updated in the execute sql task each time. The records count should be inserted into a table or flat file whichever is easy.  </p>
  
  <p>I saw tutorials how to do this without using  an update through  variable. Is there any way we could return the count of rows in my situation. </p>