They are the files that are created when you process a cube.

No, it was file contention. Our operations group was running nightly backups to tape. They had the file locked when AS was trying to update it.

FYI - I turned out that the contention was caused by our operations group running nightly backups to tape. Too bad that the event log didn't mention who was using...

Is there any way to specify different directories for different MS AS databases on the same server? This option seems to be at the server level (assuming only one instance...

I didn't ever find out how to remove it but ended up installing on our production system and things have been fine so far...

I don't understand, if this is a monthly process why not just schedule it to run every month?

I just discovered that I needed to check the Show Updates windows in Add Remove Programs in order to see HotFix 3175 and select it for removal. I was able...

Thanks Bob,

Do you know if there is any way to rollback a hotfix if there were problems with it?

Thanks Eric,

Your assessment sounds right to me. It doesn't seem to have caused any problems so far, so I'll keep my fingers crossed.

I added another measure side by side with the measure that is returning inaccurate values. The new measure has smaller values and it totals correctly (the sum of the 4...

I think you need to recreate the package every time they change the table structure. From what I've seen it looks like SSIS stores the table definition at the time the package is...

Thanks Scott, that worked. FYI - I found 2 different dtexec.exe files on my computer. I needed to specify the one located in the Program Files (x86) directory... I guess (x86) means 32-bit....    Why does Microsoft...

Hi Scott,

I'm running into the same issue with the Jet Engine. I've been able to execute Packages that import EXCEL files by changing the Run64bitRuntime parm on the SSIS Project...