Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to use For Loop Container in SSIS to execute and procedure names stored in a column Expand / Collapse
Author
Message
Posted Monday, June 17, 2013 8:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 10, 2013 6:38 AM
Points: 28, Visits: 65

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
Post #1464164
Posted Tuesday, June 18, 2013 2:02 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, April 17, 2014 1:09 PM
Points: 431, Visits: 575
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
Post #1464865
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse