Effective Control Flow Execution with 7 Different Types of Foreach Loop Enumerators

Posted by on Jul 24, 2013 in Presentations, SSIS | No Comments
Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail

Thanks for attending in my session at Pass DWBIVC today, it was my pleasure to see you there.

Today’s talk was about; Effective Control Flow Execution with 7 Different Types of Foreach Loop Enumerators in SSIS

Session description:

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.

Presentation Slides download link exists below;

 

Download Presentation Slides here:

http://www.rad.pasfu.com/speakings/passdwbivc20130725/Effective Control Flow execution with 7 different types of Foreach Loop Enumerator.pdf

Presentation video recorded and can be viewed from here soon;

http://bi.sqlpass.org/PresentationArchive.aspx

There are Tutorial Videos on samples and demos that explained in the presentation, you can download them here:

For Loop Container

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
rssyoutuberssyoutube
Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for eight continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.

Leave a Reply

Your email address will not be published. Required fields are marked *