Context: I have around 30 independent stored procedures that are currently executing in series through the SSIS package. I believe by taking advantage of parallel execution in SSIS I can gain some performance.
How to figure out the number of Execute SQL tasks that have to be configured? (get maximum out of it / optimal approach)