Hi,
Can a CSV file be used as a data source for Microsoft Analysis Services 2005?
Rgds
hari
I tried it, i couldn't get it to work. I even tried being sneaky and linking the csv in an access mdb then using the jet provider, but it didn't seem to like that either..
C|||You can create SSIS pipeline, which will read CSV's and then uses AS Processing Task to load data into partitions. I have done it in the past, and while it is not a smooth ride (especially when your partitioning scheme of the cube is not trivial), it can be made work.|||
Ahh...thanks guys!!
I will try your suggestions.
No comments:
Post a Comment