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