SSIS Tutorial Part 113-Execute SQL Queries From a SQL Server Table in SSIS Package

SSIS Tutorial Demo Scenario: In this video we will learn how to run multiple SQL Statements which are saved in a SQL Server Table. The new sql statement can be added or old can be deleted as per requirement. In any case we don't have to make any changes in SSIS Package to run the queries from SQL Server Table. SSIS Package will be dynamic to handle this. After watching this video, you will be able to learn How to Read the List of SQL Queries from SQL Server Table by using Execute SQL Task and save them into Object Type Variable How to Loop through List of SQL Queries By using Foreach Loop Container Save values from Foreach Loop Container to variable in SSIS Package Execute SQL Queries ( From Variable) by using Execute SQL Task Blog post link for the video with scripts http://sqlage.blogspot.com/2015/04/execute-sql-statements-from-sql-server.html Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers http://www.techbrothersit.com/2014/12/ssis-videos.html