SSIS Tutorial Part 112-Execute Multiple Stored Procedures from a Table by using Execute SQL Task

In this video we will learn How to Execute list of Stored Procedures those names are saved in a SQL Server Table. The video will cover following items How to store Stored Procedure names with Schema in SQL Server Table How to Read the List of Stored Procedures from SQL Server Table by using Execute SQL Task and save them into Object Type Variable How to Loop through List of Stored Procedures By using Foreach Loop Container Save values from Foreach Loop Container to variables Execute Stored Procedure by using Execute SQL Task Scenario: Think about a situation where your developers has special requirement and they want to run stored procedure from a table and they have capability to update/insert the table records. Or there is possibility that you want to have the flexibility to run more or less Stored Procedure on daily basis without changing the SQL Server Agent Job or SSIS Package. Blog post link for the video with scripts http://sqlage.blogspot.com/2015/04/how-to-execute-list-of-stored-procedure.html Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers http://www.techbrothersit.com/2014/12/ssis-videos.html