September 29, 2005 at 12:30 pm
I am trying to set up a 'ForEach... Loop' that will do something based on rows returned from a table. Actually this is part of a montoring process I have. I have a table of server/database names, I want to loop through each one and perform a task. I do the same with stored procedures right now, but thought it would be nice to try using SSIS.
Does anyone have an example, or can point me in the rigt direction towards an example. All the examples I find use a flat file input, or loop through files in a folder.
Thanks
September 30, 2005 at 7:06 am
Here's an example of something very very similar: http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
September 30, 2005 at 7:30 am
Perfect...thanks very much
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply