Hello,
I am planning to develop a custom OLE DB provider for my buffered data.
I tried loading data to Analysis Services from a CSV file using
"Microsoft Text Provider".But i have found that such data loading is
officailly not supported in Analysis services. So i was wondering if
Analysis Services will allow me to load data from my custom OLE DB
provider.
Any pointers in this regard are welcome.
Thanks in advance,
Ritu

uh why dont you just import all your little small text files into a SQL
Server database?

I am getting data in a buffer and i need to load this data to AS. I
dont want to do staging by pushing this data into a relational DB and
then loading data to AS. This is the reason i am looking into
development of a custom OLE DB provider for my buffered data.


dbahoo... (AT) hotmail (DOT) com wrote:

oh.. what's wrong with a relational database?

write a couple of jobs and have it run at night

run multiple threads on importing; and it wont take any time.

why would you be scared of a relational database?

let me guess-- you're an XML dork? or an XLS dweeb