For Loop container

Question

For Loop container

aprasy

Mr or Mrs. 500

Points: 571
More actions
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

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

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

Famson SSC Eights! Points: 997 More actions · Answer 1

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!

Jetro Ten Centuries Points: 1257 More actions · Answer 2

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

Famson SSC Eights! Points: 997 More actions · Answer 3

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.