SSIS package freezes during data flow

  • 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.

  • I think I found a way of getting around it. I guess the problem was that I had 76 columns coming through the pipeline and then I multicasted it down three paths and so I am breaking it up into pieces to be a little more efficient.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply