Executing Mass Queries

[dpgirl]

I have about 100 queries that I want to run as part of a DTS package. Do I have to set up up each query as a separate step, or is there an easier way to get them all executed in one step?

 

[fuzzyocelot]

You could always try putting them into a stored procedure and then executing the stored procedure in the package.

 

[MDXer]

if you want them to run in paralell you need a task for each query. if you want them to run in serial then you can put them all in a single task or a SP as suggested and execute the SP. If you run them in parallel remember that the number of tasks that run at the same time is controlled in the package properties.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[fuzzyocelot]

Very good point, MDXer. I forgot about running them in parallel.