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
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;
There are Tutorial Videos on samples and demos that explained in the presentation, you can download them here: