What are you doing - just drilling down on a hierarchy in BIDS or are you querying a calculated member?

It might be worth just running a trace on the server...

WTF?

I think this is way beyond my understanding....;-)

What sort of thing are you trying to do? Depending on the size row by row updates could be slow

I guess you have a few options but I think...

To do this we set-up a configuration file (Go SSIS-->Package configuration-->Add) where the location of the configuration file is stored as an environment variable

This way we only have to copy...

We are using XLCubed - an Excel addin. It's a very good tool (I don't work for them ;-)).

It's quicker than standard Excel pivot tables & has...

My guess would be driver issues.

You could run SSIS as 32bit (even on a 64 bit machine). I do this on my load to get around 64-bit driver issues

Hi,

I found that Excel (2003 & 2007) produced extremely poor MDX queries. It seems to work out the totals on rows and columns (switching this off in the pivot...

Hi RamSteve,

I also have to take Sybase data into SSIS - I found I had all sort of issues with it (such as the issue you've mentioned). It took...