Post reply

For Loop container

  • March 27, 2009 at 2:53 am

    #202295

    Hi All,

    I am newbie in SSIS. I have a question in for loop container which is, how do we insert the variable data into a table which was used in the for loop container. I dont know whether its possible or not? Could anyone make me clear

  • April 6, 2009 at 2:51 pm

    #972919

    Can you paint a clearer picture of what you are trying to accomplish? This will be very useful to decide if you are using the right tool for what you are trying to achieve.

    Cheers!

  • April 6, 2009 at 3:38 pm

    #972955

    If you want to insert the variable used in the for loop container you could use a "Execute SQL Task"-task.

    In the attached screenshots you can see how to configure this task.

    Hope this helps 🙂

    -----------------------
    SQL Server Database Copy Tool at Codeplex

  • April 6, 2009 at 11:02 pm

    #973093

    Thanks, now I understand what you are trying to do.

    create a variable for your loop counter and map the variable as a parameter to the Execute SQL task just

    as shown in the screen shot you attached to the post.

    I have attached demo screen shots. the demo inserts a file name into a table. The insert is performed the number of times stored in the counter variable.

    Hope this helps.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply