You might have more luck in finding an answer if you posted in a more relevant forum. Good luck!

MS Excel can be used to consume data from both SQL Server & Analysis Services. Microsoft also have a product called Data Analyser for querying cubes although this is more...

Coincidentally today's new article on sqlservercentral.com may be of great help to you.

http://qa.sqlservercentral.com/columnists/hji/comparisonoforacledrivers.asp

Regards

You're right. You can't get the MDX out of the cube browser. Sounds like it desn't matter any more anyway!

Regards

Don't you need an ELSE statement in there that puts something in there if IsNull(DTSSource("col").Value) = True

???

At the moment I think this will just pull through a NULL if DTSSource("col")...

Can you post your MDX statement up here for us to take a look?

Regards

Have you tried the Microsoft ODBC Driver for Oracle? I have to confess I don't know whether this requires SQL*Net installed (my suspicion is it will) but give it a...

And maybe you might be best posting this on the normal Administration forum and not the Yukon one.

Even if you choose the Linked Server option you could still wrap it all up in a DTS package for ease of manageability.

Regards

For anyone thats interested/curious....

The reason it wasn't working properly was because Kris had missed off a precedence constraint hence the export was occurring before the ActiveX script completed, hence it...

I'm guessing all it does is query the INFORMATION_SCHEMA views which shouldn't be too hard to replicate!

First thing, the last Right(blah blah blah) line is incorrect. It should read:

Right(  "0" & CStr( DatePart( "n", dt ) ), 2 )

rather than

Right(  "0" & CStr( DatePart( "m", dt...

Hi Kris,

OK, easy part first. To output a time as well as date stamp change the code to the following:

Function Main()

 Dim dt, dtstr

 dt = Now

 dtstr = CStr( DatePart( "yyyy",  dt ...

OK, first thing. Changing the text file destination at run time does just that - changes it at runtime. It is not persistent - i.e. changes made dynamically to the...

Why not just write a stored proc that takes a table name as a parameter and then does what EM does:

1. Make a note of the table's metadata

3. Copy the...