Thanks for the reply.

I actually didn't have to write an MDX script. I was lucky enough that SQL was able to figure out the roll-ups on it's own based...

We have Crystal Enterprise Server so we have a mixed environment. It delivers web based reports (can be customized to each users login), it will email reports to users (pdf,...

Gotcha, that is good to know. Are there any benefits of SSRS over Crystal? How does you deploy your reports in SSRS?

Wow, I had no idea about that. This does leave me some options (not one of which is reinstalling SQL) now that I know the cause.

Thank you for all of...

Gotcha, we are good there.

Since the file is getting created (just in the wrong place) I don't think it's a security issue at all.

I had a counterpart try this as...

Update -

The file is actually getting renamed but it is also getting Moved to C:\Windows\System32 which is why I couldn't find it and thought that it was being deleted.

When...

I went down that path unsuccesfully. I changed the SQL Server Agent Service to use the domain admin account that I created the package with. I also set the file...