Free SQL Server Integration Services Video Tutorial: Container Tasks in SSIS - An Overview of the For Loop, Foreach Loop and Sequence Containers

Container Tasks in SSIS - An Overview of the For Loop, Foreach Loop and Sequence Containers - download

Some of the greatest time savers in all of SSIS involve using the container tasks, the For Loop Container, the Foreach Loop Container, and (to a lesser degree) the Sequence Container. If you find yourself needing to iterate through a set of data (i.e., loop through a recordset) or loop through all files in a folder, then you'll need a solid understanding of the Container tasks. The BIDS environment (Business Intelligence Development Studio) does not do the best job at explaining what these tasks do and the documentation (the Books Online) are often quite difficult to work with thus making these container objects difficult to work with initially for many people.

This video is part 1 in our series and it's purpose is to explain the different types of container tasks, walk through their likely uses, and explain the use of the Sequence Container Task. The other videos in this series will go in-depth into the other container tasks in detail.

Highlights from this video:

• Formatting the containers
  
• How containers work
  
• Comparing the containers to structure programming and languages like C, C#, and Java
  
• Discussions of when you use the Container tasks
  
• Best practices for using the Sequence Container

and much more

---

• Source: http://www.LearnIntegrationServices.com/
• Category: SQL Server Videobooks
• Skill Level: 400 (Intermediate - Advanced)
• Length: 13:13 (11.3MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: foreach, for each, for(int i, collections, arrays