ForEach Loop

• Glynne Smith

  SSC Eights!

  Points: 804

  More actions

  September 29, 2005 at 12:33 pm

  #165636

  Sorry for cross posting, I originally put this in the Business Intelligence forum by mistake! 

  I am trying to set up a 'ForEach... Loop' that will do something based on rows returned from a table. Actually this is part of a montoring process I have. I have a table of server/database names, I want to loop through each one and perform a task. I do the same with stored procedures right now, but thought it would be nice to try using SSIS.

  Does anyone have an example, or can point me in the rigt direction towards an example. All the examples I find use a flat file input, or loop through files in a folder.

• Jamie Thomson

  SSChampion

  Points: 11805

  More actions

  September 30, 2005 at 7:07 am

  #594311

  Cross-posting the reply as well

  Try this: http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx

  -Jamie

   

  Jamie Thomson
  http://sqlblog.com/blogs/jamie_thomson