Yes, that's what I'm after. Tried batching:

declare @BatchSize int

select @BatchSize = 200000

while 1 > 0

begin

begin tran

insert into Destination

...