DTS

I need to get a list of tables from a tabl, then loop through the table list and execute a stored proc feeding it the table name as a parameter...

How could this best be done in DTS?

Jim

JimDi wrote:

I need to get a list of tables from a tabl, then loop through the table list and execute a stored proc feeding it the table name as a parameter...

How could this best be done in DTS?

Jim

I think this will help:

Execute SQL Task into an object variable - Shred it with a Foreach loop
(http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx)

-Jamie