SSIS Tutorial Part 114-Execute SQL Statements From a Excel File in SSIS Package

SSIS Tutorial Demo Scenario: Let's consider we have some business users and we have trained them to prepare the SQL queries for updates,deletes and inserts for some specific business tasks. They prepare an Excel File with their queries on daily basis and we need to run those queries by using an SSIS Package. What you will learn from this video How to read an Excel File in SSIS Package How to save the Data from Excel File to Object Type variable in SSIS Package How to Loop through Object type variable in For-each Loop Container How to Save record from Object Type variable into a variable in For-each Loop Container How to use the variable in Execute SQL Task when it contains SQL Statement. Blog post link for the video with scripts http://sqlage.blogspot.com/2015/04/how-to-execute-sql-queries-from-excel.html Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers http://www.techbrothersit.com/2014/12/ssis-videos.html