parallel execution of task in ssis | MaxConcurrentExecutables in SSIS | ssis tutorial part 41

[@tubewatcher97]

Thanks for showing that number of concurrent setting ! I was having trouble with them not all starting at once

[@sureshkumarr266]

What's the logic behind this "two"? (N+2, N - number of process nodes)

[@ssunitech6890]

Hi Sureshkumar,
Thanks for your comment.
As Microsoft says if we set (n+2) then that would be the best performance.
Keep watching do subscribe and share to your friends.
Thanks-SS UNITECH

[@munnaharun2431]

Could you please let me know that n+2 value in the video. If we use max concurrent value as 5 means, it should use 7 ryt?

[@ssunitech6890]

Microsoft says if we set value as n+2 them it gives us good performance...
Thanks.

[@wassimalmeniem7474]

Thank You so much for your helpfully_videos. please, if you don't mind, just I would like to suggest if you can provide us the SQL's code scripts

[@ssunitech6890]

Thanks Wassim for your feedback.
I will add SQL script in description of video..
Thanks-SS Unitech

[@vaibhavsingh4043]

Helpful video

[@ssunitech6890]

Thanks

[@nirmalaprajapati04]

Please explain in N+2 what 2 indicates here?

[@ssunitech6890]

Hi Nirmala,
2 is static number, Microsoft says if we choose N+2 number of task parallelly then it would give best performance.
Thanks-SSU

[@Prajapati_ram1996]

Good

[@ssunitech6890]

Thanks