Hands-On-Lab: Task Group Sequence and For Loop Containers in SSIS

SSIS Containers are used for different purposes; some are used to group tasks together like Sequence Container or Group. We can also use Sequence Container to run the child tasks either sequentially or in parallel. Other Containers like For Loop Container is used to run a loop n number of times where n can be any number. This lab is divided into three exercises, in the first exercise, we’ll learn how to use a Sequence Container and in the second exercise we’ll learn to use the For Loop Container, in the third exercise we’ll learn to Create a directory hierarchy automatically using For Loop Container.

Exercise 1: Containers in SSIS, Task Host Container, Sequence Container and Groups
Exercise 2: Insert Data into SQL Server using For Loop Container
Exercise 3: Create a directory hierarchy automatically using For Loop Container

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.