Yes, the restore is automated. However we're using Veritas for this function so I can't say for sure that you could do it with native SQL Server tools.

And yes,...

RS 2000 doesn't support this feature natively, but I found someone that has implemented an extension to RS that does:

http://www.devx.com/dbzone/Article/21214/1954?pf=true

As far as SQL 2005, its hard for me...

We have six servers in a poor man's high-availability setup:

(2) SQL servers

(2) web/portal servers

(2) file servers

One SQL server is primary and serves up database queries for the active web server....

Yikes! 5GB! Well, if you can't figure out how to make it smaller...

What about storing it in ROLAP mode instead of MOLAP? That way you can use...

That's a really big cube!  Why is it so big?  How many dimensions and levels? Is there really that much dimensional info, or are you actually storing detail-level data in...

I assume you are doing this from Analysis Manager?  What service pack are you running?  You should be at least at SP3 of both SQL Server 2000 and of Analysis Services...

Could it be that you're using a user-based DSN in your connection, and that DSN is not available to the user account running SQL Server?

As a side note, I find...

I don't know if it would be any faster (depends on resulting execution plans, table sizes, etc), but what I've done in the past is just set the max error...

You've got the classic DTS oops - point-and-click ease, but poorly designed ETL.  DTS (in SQL 2000) is great for putting together stuff quick, but it doesn't provide an automatic framework...

Sounds lilke you're running out of swap space!  This is what we call a Bad Thing in the world of ETL.  You can verify this is the condition you're experiencing...

that's why i use unix shell commands to do pre-parsing, its a lot more flexible.  but try this to get what you want:

type TestData.txt | find "DETAIL" >TestData_Detail.txt

i don't know...

I just had to deal with this myself.  I find that a lot of simple text-based manipulation and filtering is most easily done with batch scripts BEFORE I bring them...