There's no silver bullet or go-faster switch if that's what you're looking for (http://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/)

Profile the data load, identify which parts are slow and work on optimising the bottlenecks. Repeat until it's running fast enough.

This may give you an idea where to start

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/