I have an SSIS package set up like this:
Here is an image of the flow (I can't post image tags yet).
If I run only the New Rows flow the Bulk Insert finishes without a problem, but as soon as i connect the Live Rows flow the package stalls indefinitely. When I check the activity monitor the Update Newer Table Rows task stalls, blocked by the Insert New Rows task.
Why does the Bulk Insert not finish? What can I do tho make the package execute?
NB: I'm well aware that this might not be optimal, but I'm really interested in getting answers to the question as it is stated. Thanks!
This is a cross post from Stack Overflow, question 2026625.