locked
CSV file as a data source RRS feed

  • Question

  • Hi,
    Can a CSV file be used as a data source for Microsoft Analysis Services 2005?


    Rgds
    hari

     

    Friday, February 23, 2007 4:54 PM

Answers

  • 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.
    Friday, February 23, 2007 8:09 PM

All replies

  • 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
    Friday, February 23, 2007 7:14 PM
  • 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.
    Friday, February 23, 2007 8:09 PM
  • Ahh...thanks guys!!
    I will try your suggestions.

    Monday, February 26, 2007 4:10 PM