How to run packages parallel

Question

Hi,

I have 4 packages

1.dtsx,2.dtsx,3.dtsx,4.dtsx

i created a main.dtsx package and i am calling all the above 4 packages in that.

My question is how to run all those packages simulteniously(concurrently)?

currently those are running sequentially.

Answer 1

Hi Uday,

Have you tried this suggestion? http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ba5e3a13-2f9f-4ece-8a50-98269849b695/

Also, please note that you can also scheduled all your 4 packages in SQL Agent at the same time and they'll run in parallel.

Hope this helps!

---

Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

Answer 2

Hi

Is there any other way to do run all the packages concurrently?

Answer 3

copy all the contents of all packages and put it one single package and execute that single package. thats it. they all will be executed paralally based on memory distribution.

regards

joon

Answer 4

Create a Master Package, drag four execute package task (EPT), Specify the connections to all the EPT's(1.dtsx,2.dtsx,3.dtsx,4.dtsx).

Go to package properties and set MaximumConcurrent Executables to 4  by default it will be -1.

This will work for you.

Answer 5

Use 4 "Execute Package Task" in Main.dtsx and let them point to 1.dtsx,2.dtsx,3.dtsx and 4.dtsx respectively. Run Main.dtsx and all the packages will be invoked at the same time. So simplicity you can let SSIS manage how many concurrent threads can be fired at a time.

---

~V