title: SSIS package - loop through different connections for Execute SQL task
body: <p>I am creating an MSSQL2008 SSIS package to generate and email reports from database tables. It works perfectly on a single database.  The client is running 3 different databases used by 3 different divisions.  The database structure is exactly the same. All three databases are located on the same server, same security / credentials are used.</p>
  
  <p>I created a "For Each Loop Container" in my SSIS package that loops through the list of 3 items and populates it into a variable.  How do I now take that and pass it to the "Execute SQL Task" to run three times (once for each database)?</p>
  
  <p>Thank you for your time!</p>