Thanks for the help, Brandon.

OK, sorted out my date problem - "SET DATEFORMAT dmy" before the bulk insert.

I appreciate all your help and suggestions.

Using some fieldterminators ("\",\"") in the format file, I am able to get rid of the double quotes.

I now have a new problem though...

Thanks for your help and advice Gary.

My initial solution to our problem was to use views, but that was not desired by the powers that be.

That led me to look...

Also, have you installed service pack 3.

I was also having this problem, installed sp3 and it all worked fine.

Thanks for your help AnzioBake.

I tried your suggestion, but I get an error stating all the columns are not contained in a GROUP BY clause.

Thanks for your help, NPeeters.

I tried what you suggested, but keep getting an error saying Incorrect syntax near the keyword 'GROUP'.

I have tried changing things around, but still get errors.

...

The fact and the dimension tables must be from the same data source (so the error messages tell me).

What I have done is, on the remote dimension tables (linked) server,...

Thanks for you help Frank.

I considered that, but i couldn't determine how long data in those columns are.

I tried doing a LEN(column_name) > 8000 Query, but i got an error...

My 2 cents worth: I was having problems a while ago with the ntext data type and Analysis Services. I ended up leaving it out and haven't tried since so...

Sorry, those articles I suggested deal with ASP, and not VB, but you should still get the general idea.

You will need to reference Microsoft ActiveX Data Objects as well as...

The following article should be of help:

http://www.microsoft.com/msj/0899/mdx/mdx.aspx (Part 1)

and

http://www.microsoft.com/msj/0999/mdx/mdx.aspx (Part 2)

HTH,

Ryan

You need to connect to the cube via ADOMD, and then you can query the cube using MDX (Multi-dimensional Expressions).

(see Books OnLine for more info on MDX).

Thank you NPeeters. I tried out your suggestion and it all seems to work exactly as i was wanting, i appreciate it.

Thanks again to all of you for your help.

Ryan.

...

I'm not quite sure that I fully understand you, NPEETERS.

Could you please expand a bit more on your suggestion.

I appreciate your time and effort.

Thanks.