Nested foreach loop containers

• mtz676

  SSCrazy Eights

  Points: 9255

  More actions

  September 19, 2017 at 4:21 am

  #402500

  I know how to build an SSIS package using a for each loop container.

  But how do I build an SSIS package which has nested for eachloop containers.
  My idea:
  Execute SQL task - gives list of server names
  Outer For each loop container - holds the list of server values in ADO Enumerator and also points to the existing server using a variable(currentserver).

  Now I need an inner for each loop container inside this outer one.
  As my outer for each will have serverlist(variable) and currentserver(variable)
  Now using the currentserver variable I need an execute sql task which holds the list of databases in this currentserver(variable).
  Against each of this database I need to run a query(using dataflow task).I will be storing the sql query results in a sql table(oledb source
  and oledb destination is used query and store query results.)

  I declared 4 variables
  currentserver
  serverlist
  currentdatabase
  databaselist

  I cant find any online resources.
  Any guidance is appreciated.

• Thomas Rushton

  SSC-Insane

  Points: 22649

  More actions

  September 19, 2017 at 4:31 am

  #1959917

  This sounds like the sort of thing that David Bird went through as the core of his SQL Overview system.  There's a series of articles - the first one discusses the basic server list / SSIS processing core that you could adapt to your own requirement.

  Thomas Rushton
  blog: https://thelonedba.wordpress.com