Sink successful while source is still queued

%3CLINGO-SUB%20id%3D%22lingo-sub-2709158%22%20slang%3D%22en-US%22%3ESink%20successful%20while%20source%20is%20still%20queued%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2709158%22%20slang%3D%22en-US%22%3E%3CP%3ELooking%20for%20any%20guidance%20to%20this%20issue.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3EThe%20Sink%20is%20already%20successful%2C%20but%20the%20data%20flow%20activities%20used%20by%20the%20sink%20are%20queued.%20As%20a%20result%2C%20the%20data%20isn't%20committed%20in%20the%20destination%20table%20and%20I%20keep%20getting%20timeouts%20as%20a%20result.%20%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3EI%20changed%20the%20SQL%20Based%20source%20to%20Read%20Committed%20(was%20Read%20Uncommitted)%2C%20and%20it%20yielded%20the%20same%20result.%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2709158%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMapping%20Data%20Flows%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Looking for any guidance to this issue.  

 
The Sink is already successful, but the data flow activities used by the sink are queued. As a result, the data isn't committed in the destination table and I keep getting timeouts as a result.
 
I changed the SQL Based source to Read Committed (was Read Uncommitted), and it yielded the same result.
1 Reply
So, this is a bit misleading as the status shows success, but the sink has not completed/committed the batched changes. Due to performance reasons, it was taking 2.5 hours to insert the 720k+ records, but was still indicating success. Seems the status should have remained "in progress" until the sink was complete.