Another daft question maybe, but are you restoring the OLAP database onto it's original server, or are you moving it form one server to another?

If moving it from one server...

Thanks for your replies.  I think we're going to try a different approach rather than DTS.

Just to make my question a little clearer, I'll explain the scenario.

We have a SQL...

I'd check what's going on behind the scenes on the server itself!  Is it just this particular insert statement which is running slow, or is it everything in general??