Are you loading the fact table from parallel data flows and running them concurrently?

Try the SQL Bulk Copy Component from http://www.Aichabiis.com; it was designed specifically to make it easy to speed up large data loads. It will allow you to effortlessly...