Wednesday, July 25, 2012 1:27 PM
I have 4 packages
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.
Wednesday, July 25, 2012 1:37 PM
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
- Edited by Shahfaisal Muhammed Wednesday, July 25, 2012 3:53 PM
Wednesday, July 25, 2012 2:35 PM
Is there any other way to do run all the packages concurrently?
Wednesday, July 25, 2012 3:05 PM
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.
- Edited by Joon84Microsoft Community Contributor Wednesday, July 25, 2012 3:05 PM
Wednesday, July 25, 2012 3:10 PM
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.
- Edited by Kingxxx1 Wednesday, July 25, 2012 3:17 PM
Thursday, July 26, 2012 11:35 AMUse 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.