how to use For Loop Container in SSIS to execute and procedure names stored in a column

• signforarun

  SSC Journeyman

  Points: 96

  More actions

  June 17, 2013 at 8:14 am

  #294775

  Hi all.

  I need a good resource to figure out how to use For Loop Container in SSIS in order to do the following:

  1) Call up Procedure name from a SQL Table, looping through them one by one

  Procedurename

  Exec proc1

  Exec proc2

  exec proc3

  2) By executing them i will be getting result set which i need to insert it in to another table

  Table structure

  Thanks,

  Arun

• ahperez

  SSC Eights!

  Points: 962

  More actions

  June 18, 2013 at 2:02 pm

  #1625212

  Take a look at these articles and see if you can adapt these techniques to your needs:

  http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/

  http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/99287/

  http://www.codeproject.com/Articles/14341/Using-the-Foreach-ADO-Enumerator-in-SSIS

  http://sqlblog.com/blogs/eric_johnson/archive/2009/11/13/ssis-2008-looping-through-rows-in-a-table.aspx