As a rule 99% of the time you should never use linked tables from Access to SQL.  It's just a very good way to snarl up your SQL server.

I always...

As for the "offline" cube, do you know how that is stored?  I think it might still be the same format as local cube files as they are what Excel...

Check that the month ids are unique to each year, to avoid cross joins.

For dates the best bet is useually a date field that you format into YMD.  AM has...

You can't modify this SQL directly in Analysis manager.  What do you mean by duplicate records?  Can you send the spec of the cube you are trying to build?

Never mind, found it out anyway.  It's because it occures in the:

SET TRANSACTION ISOLATION LEVEL

statement.

Yeah, but with Yukon I can make the whole thing run server side in C#.

I'll do something on tha once the public beta is out

Lastly I have the habit of casting string dates to DateTime.

AND MT_DATE >= Cast('2003-11-29 00:00:00.000' as DateTime)

This is implit anyway, so it will make no difference to the plan, but...

This looks like an indexing problem.

Can you execute this query with set showplan_text on and paste the results here?  This will allow us to look...

Instead use the UNC for the share that you have mapped the drive to (\\server\sharename)

I just had it again.  A reload useually fixes it, but I get a status message of "Download Your Evaluation Copy Today", whatever that means

I get the same bug , but it useually goes when I reload the page.

Also never use mapped drives.  They are yet another stray thread you have to keep track of.

It's because all indexes and statisitics have a reference stored in the sysindexes.  The indid field is the unique id for the hard disk location of the data or...

How about running two DTS packages, both sceduled to run at the same time? 

That's because there is a long line (line 4) in a <pre> tag that shouldn't be.