Learn SSIS : For Each loop

Welcome back..Today I am going to cover ForEach loop.
ForEach loop we use when we don’t know the number of iteration loop, lets take an example…
The scenario is in adventure works database we have a view vEmployeeDepartment, so what we are going to do is we will be generating files by department name.
Let’s start..
The package will look like this…

Learn SSIS : For Loop in SSIS 2005/2008

After lots of failure attempts finally I am confident enough to write my first post. It took like 3 years for me to start writing this first post. And you know what, its not that simple!!.

Anyways feelings aside, and lets starts something which is of our interest.

Yeah we gona start with Loops in SSIS, well there are two types of loops available in SSIS 2005/2008

1. FOR Loop : Use when you know the count of iteration of the loop
2. FOREACH Loop : Use when you don’t know the count of Iteration of loop