Combining Queries

[HLPCH]

Hi, I wanted to know if there's any way to execute a bunch of queries in the DTS Package.

I use the execute SQL Task to run the queries against a database. But I would like to run 15 queries all at once very similar to the Batch process. Basically wanted to know if I could have a series of SQL statement in one Execute SQL Task.

Is this possible?

Thanks

CS

 

[MDXer]

Yes. Or you could have 15 seperate ExecuteSQLTasks. Depends if you need/want the procs to run in parallel.

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