New SQL Server Integration Services Video Tutorial: Pt. 2 of Working with the Container Tasks - the For Loop Container

Pt. 2 of Working with the Container Tasks - the For Loop Container - view details

The For Loop Container is akin to working with a programming language like C/C#/VB/Java in this respect:

for (int i = 0; i < 10; i++ )
{
���� // do something here
}

or, in a SQL language:

DECLARE @i INT
SET @i = 0
WHILE @i < 10
������ BEGIN
������ ���� -- do something here
������ ���� SET @i = @i + 1
������ END

These types of loops/iterations are very commonly needed in programming languages and, if you need to do them in SSIS, you can - BUT you have to know the expression syntax to do so!

---

• Source: http://www.LearnIn tegrationServices.com/
• Category: Creating SSIS Packages - Container-based Tasks
• Skill Level: 400 (Intermediate - Advanced)
• Length: 19:53 (17.3MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might wish to view our free database videos.

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

---

Keywords Associated with this video: expression builder, expressions, @counter, variables, iteration, iterate, recursion