May 20, 2010 at 11:52 am
Hi all,
2 part question. I have a SSIS package which has about 15 data flow tasks. These tasks don't need the success of one another in orther to run so I's like them to all go at once. When I fire off package only5 or 6 of them turn yellow and begin processing. As these complete, the other ones beging processing. I'd like for all of them to process at once. Is there a property or setting which will allow for all of them to process at once?
Secondly, when processing all at once is there a way to set a higher priority on some tasks than others?
Thanks,
Strick
May 20, 2010 at 2:06 pm
stricknyn (5/20/2010)
2 part question. I have a SSIS package which has about 15 data flow tasks. These tasks don't need the success of one another in orther to run so I's like them to all go at once. When I fire off package only5 or 6 of them turn yellow and begin processing. As these complete, the other ones beging processing. I'd like for all of them to process at once. Is there a property or setting which will allow for all of them to process at once?Secondly, when processing all at once is there a way to set a higher priority on some tasks than others?
1. Yes, at the package level there is a property called MaxConcurrentExecutables, however it is defaulted to -1 which translates to the number of logical machine processors plus 2.
From: http://technet.microsoft.com/en-us/library/cc966529.aspx
2. I'm not aware of anything other than precedence constraints.
I want to make a point though that there are practical considerations to the maximum number of threads of execution that can run that goes beyond available cores. You may not be able to get all 15 running at the same time no matter what you do. As well as that they might all be running when on more powerful machine.
CEWII
May 20, 2010 at 2:29 pm
Gotcha, thanks.
Strick
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply