N/APosted on - 06/27/2011
I have designed 3 Execute Process task and 3 Execute SQL task in a single editor consecutively in SSIS. I was trying to run all the tasks simultaneously in SSIS. But sometimes up to 4 tasks run parallel. Sometime up to 3 tasks, after that it fails. Is there any trick to run all the 6 tasks in parallel? Is there any property that has to be set to do this?
Issue in executing multiple tasks simultaneously in SSIS
As per my knowledge I have been working in SSIS for more than 4 years. I don’t think that there is any property to run multiple tasks simultaneously. This situation could create a bottleneck of threats in SSIS. It may depend on your number of cores in the CPU and its performance.
It is purely based on the resource allocation of the SSIS. If you are an expert in Computer Resource Management it may be achieved using some tricks. This reply is not the solution for the issue, but the information may redirect you to refined solutions.
You can try with the computer which has more cores in its CPU. Try providing top priority in the task manager for this process. You can also try to put all 3 processes in a batch file and run it from the Execute Process Task and put all the SQL statements in the Execute SQL task.