I have a SSIS package. In the package there are several packages. In one package the task is to execute around 25 stored procedures. I have divided those 25 stored procedures in 8 block. 8 blocks run in parallelly. I found that while executing those stored procedures at random time the SSIS goes in sleep mood without giving any error. Sometimes its in sleep mood for 1 hour, sometime it is in sleep mood for more then 12 hours.
I tried multiple things like instead of 8 blocks i tried 4 blocks, the result is same. But when i run all the 25 stored procedures 1 by 1, the ssis does not goes into sleep mood. it completes all the task including executing 25 stored procedures within 4 min.
SSIS was in sleep mood from 10th jan 10.38 pm. Finished on 11th jan 3.13 pm.
This is the Main SSIS Package.
This is the inner package at step 6 where 25 SP run. Currently it is designed in 8 block. In each block 3 SP's , runs 1 by 1. Each blocks run separately
I need some help regarding why it is going in sleep mood. What i need to do to prevent this.
MD. Atibur Rahman