for loop container in SSIS

WHAT IS THE USE OF THE FOR LOOP CONTINER

PLEASE GIVE ME THE EXAMPLE

REGARDS

KOTI

If you have a variable set to an integer of 10, you might use a for loop to iterate 10 times, the contents contained therein.

A for loop will start at a given point (myVariable == 1) and increment by 1, perhaps, till it gets to the end (myEndVariable == 10).|||

hi brother i placed the controle and declare a variable i with increment that is repeating to 10 time fine

but inside the forloop of i place execute sl statment i want to insert the i valu to the sql command i was give but it

always inserting 1 only but not accordingly what we are incrementing .

so please give real time example for this usage

@. = @. + 1

|||

Configure the Exec SQL Task to use the variable. See the Parameter Mapping feature.

Configuring the container should be simple enough.

For Loop Container Samples
(http://www.sqlis.com/310.aspx)