SQLTeam.com | Weblogs | Forums

Run parallel query through package


#1

How to parallely run the a single procedure 5 times by package.The procedure will load a table which have 100 queries in that table.each will execute sequentially now.how to parallely do it and improve performance?


#2

if by "package" you mean integration services package, then it's easy. use 5 Execute Sql tasks, with no precedence constraints between them.