We upgraded our production server to enterprise edition last night because
we received this error deploying cubes.  The issue still occurs, any ideas?
Regards,
Nick.

I am using Data Flow task for the below query.
I have a source connection as MyOrclConn which uses Oracle Provider for OLEDB.
I am trying to write a query which selects the records from Oracle based on
the RunDate that is in Audit_Date in SQL Server Db (MySqlSvrConn).

I have been handed a SQL Server 2000 data warehouse. The tables do not have
clustered index. There is not enough disk space to create clustered index at
this time. Each table has non clustered primary key index only. The delete
statement is based on data being loaded into a ...

I mostly work on sql2005 and our test team is working on sql2008 adoption,
I wonder if 64bit strict approach on datawarehouse table may raise potential
performance issue;
I mean:

I have a subreport that contains a table that has values showing total
expenditure over the year for a given location.  The columns are as such:
(Location Name), Jan, Feb, Mar, Q1, Apr, May Jun, Q2, Jul, Aug, Sep, Q3,
Oct, Nov, Dec, Q4, Total, %Total.

We have done some refactoring and decided to remove some dimensions from our
CUBES.  Our cubes are set up as monthly snap-shots.
My question is what do we do with previous snap-shots that have referances
to this dimension we are wishing to drop?  I beleive we should make every

I really need your input for the following  architecture data
warehousing.
I was suggested to create an ODS after staging the data and then
create a dimentional DB