I have an SSIS package in which I am trying to do incremental loads as well as change data capture. I am not sure why it just hangs, but I have tried changing my Lookup transformation to a merge join and that did not seem to do anything. Does anyone have any ideas, see the attached screenshot of my data flow.