sql server - SSIS going in sleep mood with parallel execution of a one of the package

Question

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.

Thanks MD. Atibur Rahman

Answer 1

等待大神答复