November 4, 2024 at 8:47 pm
Hi everyone
I am trying to implement parallelism in my SSIS package. There are about 20 SP in total that have various dependencies on them. I organized them into 3 SSIS Sequence Containers called Step 1, Step 2, and Step 3. SPs in Step 2 depend on SPs in Step 1 and SPs in Step 3 depend on SPs in Step 2. Each SP is run by Execute SQL Task. Each container is connected by a precedence constraint (ie success).
I have two version of SSIS setup. First one is where each SP is executed in linear order (ie no parallelism). The second one has parallelism implemented. First version works fine. Second version is having issues. I created the various Execute SQL Task in parallel by ensuring they have no precedence constraint attached to it. For some reason, some of the Execute SQL Task will not finish. I wait for over 30 minutes at times and still nothing. The SPs behind the Execute SQL Task take close to 20 seconds or less to finish so I don't think it has anything to do with the SP logic. I think it has something to do with the way I implemented parallelism. The issue appears to be random. Each time I run the SSIS package I get different Execute SQL Task having an issue. What could be the issue? Please give me ideas on what I should investigate further. This issue has me really stumped b/c its always a different Execute SQL Task that is not finishing.
Thank you
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply