title: SSIS package to loop through databases to find a table and delete older rows
body: <p>I need help in creating a package that iterates through databases in a given server, looks for a table name that contains the word 'EventLog' and delete all rows older than a year. The deletion should be in batch of 50000. </p>
  
  <p>I was able to read the database names using Execute SQL task, stored the full result set in a object type variable and used for each loop container to read the results from the variable and need help from there</p>