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

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

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

Hello Friends,

Here is another popular lab from Hands-On-Lab library: 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.

Learn More
 

 
Happy Learning – The Practical Way.

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

By |2020-09-02T11:52:32+05:30August 25th, 2020|HOLs|0 Comments

About the Author:

Leave A Comment