The best suggestion I could give is to batch your inserts into the table instead of trying to do it as a single insert. Be sure that you put a slight delay between batches to give SQL Server some breathing room for other work.