Update

It is a while since I posted the original question. I have since had a few problems with the SQL Agent running SSIS packages.

I seem to have overcome...

Daniel,

Thanks for you reply.

This problem was really getting to me so I had made sure all the regional settings for all the users for every computer with 100m where...

I just realized that this is a sub forum of SQL2000 and the above relates to SQL2005. Now posted in SSIS forum. 

Bump.

I got round this by firing some batch files but now I am starting version 2 of the project and seems a shame that MS has gone to the trouble of...

I'm using the Standard Edition in production and use SSIS packages which all work. In fact I have not found anything on the Development that doesn't work on the Standard. I guess the...

Bump. Still no solution to this one ?

I have had similar problems. More memory seems to help. I upgraded my development machine to 1Gb and it appeared to run better. On one server with 2* 3.2 processors and 2Gb of...

With the cube analyser I think you can only choose items on a page filter.

I find it is much better to bring the cube into a normal Excel pivot table....

Bump. Anybody any ideas ?

Update.

When connected to a domain name server it works. You need to create a role in the Analysis Server database with the user name in.

Carl

Steve,

Many thanks for the reply - I was beginning to think I was on my own with this one.

I tried adding a role but it did not help. The problem...

Thanks for the reply.

No. I have NOT setup any roles yet.

Do you think I need to for it to work ?