Jack,

I get this error in the event log upon running a simple select.

EventType clr20r3, P1 sqlwb.exe, P2 2005.90.1399.0, P3 434f6009, P4 system.drawing, P5 2.0.0.0, P6 471ebf30, P7 181, P8 20,...

I believe I've discovered what was occasionally causing the cube processing errors. In my SSIS package to process the cube I selected all objects (database, cube, and dimensions). ...

Thanks, Dan.

I am certain the dimension tables are being refreshed. The job step that refreshes the dimension tables preceeds the cube process step. After the cube process step...

Thanks, Jeff.

Not being a DBA I want to make sure there will be no adverse effects of turning Autoclose off. Can you think of any reasons why I wouldn't...

Jason,

Yes I have. I don't get errors when processing the cube from AS. The SQL Server agent job step that processes the cubes errors approximately 20% of the...

Thanks, Sriram.

Will you get me started with instructions on how capture the log file in SSIS?

Thanks.

Never mind. I got it figured out. I needed to drag/drop the attribute from the Data Source View section into the attribute section on the Dimension Structure tab.

Thanks, Rick.

SSAS is new to me. That said, I don't think I'm restricting any dimension. I've given read access to all dimensions to the user role.

I'll look into...

Thanks, Rick.

I have two roles. One for myself as the administrator and a second role for the users. Right now I am just testing the cube and roles...

Thanks, Rick.

I forgot to mention that I'm using SQL Server 2005 Standard Edition, which does not support perspectives.

Thanks, Dan.

Conan,

I used SQL Server Management Studio 2005 to import the Access table to a SQL Server 2000 database. This is a one-time import.

There is a DTS package that transforms...

Thanks, Frank.

Thanks, Ed. The Access 97 database is not a database that users open. It's a reporting database with tables that is used by our reporting system. It...

Thanks, Dugi.

I create a linked server to MS Access. The linked server works for a day or two, then it fails. Deleting and re-creating the linked server does...