locked
for loop container in SSIS RRS feed

  • Question

  •  

    WHAT IS THE USE OF THE FOR LOOP CONTINER

     

    PLEASE GIVE ME THE EXAMPLE

     

    REGARDS

    KOTI

    Monday, August 13, 2007 12:32 PM

Answers

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

    Tuesday, August 14, 2007 10:17 AM

All replies

  • 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).
    Monday, August 13, 2007 1:46 PM
  •  

    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

     

     

    @Idea = @Idea + 1 

    Tuesday, August 14, 2007 4:30 AM
  • 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)

    Tuesday, August 14, 2007 10:17 AM
  • 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
    Tuesday, February 1, 2011 7:37 AM