Forum Discussion
Sink successful while source is still queued
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.
- 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.
