Effective Control Flow execution with 7 different types of Foreach Loop Enumerator
Recorded on 24 Jul 2013 at PASS Data Warehousing and Business Intelligence Virtual Chapter (PASS DW/BI VC)
Effective Control Flow execution with 7 different types of Foreach Loop Enumerator
Controlling execution of tasks in Control Flow tab of SSIS package can be much easier with getting help of Foreach Loop container. Foreach loop container provides ability to loop through items of a list. There are 7 types of enumerators for using in this Foreach loop, which provides wide range of lists to be used in loop structure. For example looping through array of items in a variable, or nodes and elements of an XML data, or looping through excel sheets, looping through SQL Server data objects.... In this session audience will learn about all 7 types of enumerators, and real world scenarios of using them in SSIS packages.
One of the main benefits of loop structures are helping in creating dynamic task execution, for example dynamic data flow. In this session, there will be samples of creating dynamic data flows with help of Foreach Loop enumerators.
Speaker:
Reza Rad is an Author, Trainer, Speaker and Senior DW/BI Consultant. He has a BSc in Computer engineering; he has more than 10 years' experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in SQL Server for three continues years (from 2011 till now) for his dedication in Microsoft BI. His articles on different aspects of technologies, especially on MS BI, can be found on his blog: http://www.rad.pasfu.com .
He wrote some books on MS SQL BI and also is writing some others, He is also an active member on online technical forums such as MSDN and Experts-Exchange, and is a moderator of MSDN SQL Server forums, and is a MCP, MCTS and MCITP of BI. He is the leader of New Zealand Business Intelligence users group.
He is a Technical Speaker in TechEd, SQL Saturdays, SQL users groups, and Conferences. And He is a Microsoft Certified Trainer.
Join PASS DW/BI Virtual Chapter at http://bi.sqlpass.org
Follow us on Twitter @PASSBIVC