I suspect that the performance problem is because the insert destination is committing each row as it goes. Check the insert destination- the data access mode should be something like 'Table or View - Fast Load".