SQL Server Integration Services (SSIS) Part 10 - Sequence Containers and FOR Loops

By Andy Brown

- creating and using sequence containers
- using FOR loops to iterate a number of times round a loop

[jahangirkabir]

Great video saving life! God bless you, Sir.

[groentas]

When searching for primes, you can increase the testnumber with 2 every time, since an odd number can’t be a multiplum of only even numbers.
The initiation should check wether the limit is >=2, since 2 is not an odd number smaller than 1.

[haatpraat]

Perhaps when mentioning Sequence Containers transaction processing can also be mentioned. You could have say 3 different Execute SQL tasks in a Sequence Container that update a table. If the transaction property of the Sequence Container is set to 'required', then if any of the tasks fails within the Sequence Container ALL of the work of those tasks are rolled back.

[pratapchava]

I hope this was useful..

For Script task1:

int
int i;
bool IfPrime = true;
for (i = 2; i<TestNumber; i++)
{
if(TestNumber % i == 0)
{
IfPrime = false;
break;
}
}
if (IfPrime == true)
{
string PrimeString =
PrimeString += ", " + TestNumber.ToString();
= PrimeString;
}

For Scripttask2:

int MaxNumber =
string PrimeString =

MessageBox.Show("Primes up to " + MaxNumber.ToString() + " are \n\n" +
PrimeString);

[mrleokarthik]

Excellent Tutorial for beginners, Can you provide SSIS files from all the lessons.

[UriGerhard]

What's up with the audio on this one?

[Anatoli]

It's getting a bit harder because one have to add manually a lot of code to get it to work. While this is fun and good learning, for demonstrating certain features, perhaps some code could be provided? It was perfect, until this tutorial. Thank you, anyway.