The PASS Business Intelligence and Data Warehousing Virtual Chapter serves to connect BI professionals globally over ongoing webinars.

 

Web: http://Bi.sqlpass.org | Twitter: @PASSBIVCEmail:  

 

PASS DW/BI VC


PASS Summit 2016
              

PASS SUMMIT 2016

$150 off Registration Discount Code

VC15BRD5

August 2016 Upcoming Session


 

Next Meeting

Wed, Jul 24 2013 13:00 Pacific Daylight Time


SSIS: Effective Control Flow execution

RSVP: https://attendee.gotowebinar.com/register/1504630336516349696

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.


Reza Rad is an author, trainer, speaker, and consultant. He has been a Microsoft Data Platform MVP for six years, specializing in Microsoft Business Intelligence and data movement. Reza has worked with Microsoft BI technologies more than 15 years. He is an MCP, an MCT, and co-leader of the New Zealand Business Intelligence Users Group. He has previously published, and is currently writing, several books. You can find his technical articles on his blog at http://www.radacad.com. He is author of books: SQL Server Integration Services, Microsoft SQL Server 2014/16 BI, Power BI online book from rookie to rock star, and author of Channel 9 SSIS tutorial video series. he speaks in many conferences listed on his website's presentation section.