It looks like your issues\causes are different from mine.

I do not have any sorts\merges. It is a straight SELECT from DB2 table (only one of them) and load into SQL server table.

And using a query as a source causes the problem...

And I can not use a table or a view as source because they are just too big.