Hands-On-Lab: SSIS Foreach Loop Container

SSIS Containers are used for different purposes; some are used to group tasks together like Sequence Container. Other Containers like Foreach Loop Container is used to run a loop for each member of a specified enumerator. This lab is divided into three exercises, in the first exercise; we’ll learn how to use a Foreach Loop Container with ADO Enumerator. In second exercise, we will learn how to use Foreach Loop Container with File Enumerator. In third exercise, we will learn how to use Foreach Loop Container with Item Enumerator.

Exercise 1: Containers in SSIS, Foreach Loop Container – ADO Enumerator
Exercise 2: Containers in SSIS, Foreach Loop Container – File Enumerator
Exercise 3: Containers in SSIS, Foreach Loop Container – Item Enumerator

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.

Get weekly learning resources from SQLMaestros, right in your inbox. Subscribe to our Bulletins.