Processing cubes directly from .csv files (bypassing SQL Server overheads)
Posted on 2003-03-19
I am considering the possibility of using the .csv file of data I currently have to process cubes, without transferring the data first into SQL Server DBs (with DTS). I am wondering if this is possible or I should accept the overheads associated with dealing with the data in the database (I'm looking for the most efficient way to create cubes). I got the idea for this from noticing the Microsoft Text Driver in the ODBC connections on my machine; does this connection allow me to bypass the database? If not, what is the MS Text Driver for?
Thank-you very much for any help!