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?
if by "package" you mean integration services package, then it's easy. use 5 Execute Sql tasks, with no precedence constraints between them.