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 controleand 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)

Some more For Loop Container examples: Do something ten times Wait untill a certain time Wait for a couple of seconds / minutes http://microsoft-ssis.blogspot.com/2011/02/how-to-configure-for-loop-container.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com