We can't help you. We have no idea what data you're loading, what depends on other data, or any other way that we could comment on ways to optimise the load process. We also cannot see the SQL you're using, so we can't comment on how to optimise it. In short, you have given us nothing to help you with.
Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )