I'd love to be in Hendra's position...... a datawarehouse that isnt mission critical. What a joy that would be. We have several real time cubes that make our datawarehouse mission...

Wow Ben, how did you find this little nugget? any more like that would be great.

Also Hani, have a look at http://www.sqlservercentral.com/Forums/Topic444600-147-1.aspx of search this site, this question...

This is just one of the many reasons I love this site. My first task today was to start looking at PerformancePoint and what do I find - a very...

This could be a very lengthy reply, but I'll cut it down to a few lines.

Your aggregating data, therefore, a datawarehouse could really help, for a start a database is...

The bonavistasystems stuff looks pretty neat and by acquiring XLCubed have a lot of Excel integration experience behind them. I've not load tested it or seen what impact it has...

Have a look on page 21 of the following and see if that helps.

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

I've not tested this myself but there’s always been a niggle in the back of my mind that using views instead of base tables when building dimensions and cubes might...

Jane,

As another point you cant process any AS2000 OLAP objects form a SS2005 SSIS package.

I'd second that approach, I did the same and it all went well. OK it was a pain with over a hundred packages but we got the best results this...

Am I right in thinking your going from SS 2000 (32 bit) to SS 2005 (64 bit)?

Please dont tell me your on Itanium 2's and you need to connect to...

Welcome Wendell Sá, good to see new blood.

I think Chad and myself dont have any issues with importing DTS packages and keeping the format its the fact that when we...

Have a word with the Oracle DBA it could be that teh SQL Server Agent has been set up with the correct rights but your user hasnt, so when you...

Service Pack 2 did nothing for us on this score.

I experience this as well but I just put it down to one of the many many many many bugs in 2005. Now that I know you should be able...

Being able to run a package successfully while it using the service accounts and not being able to run it manually from Visual Studio makes me wonder if it is...