sp_configure
sp_configure 'show advanced options', 1
reconfigure
sp_configure 'Ad Hoc Distributed Queries', 1
select * from [Customers_A-F]
insert into [Customers_A-F]
SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=D:\Temp\;','SELECT * FROM [Customers.csv]')
sp_configure 'show advanced options', 1
reconfigure
sp_configure 'Ad Hoc Distributed Queries', 1
select * from [Customers_A-F]
insert into [Customers_A-F]
SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=D:\Temp\;','SELECT * FROM [Customers.csv]')
http://www.accelebrate.com/sql_training/ssas_tutorial.htm#creating_datacube
ReplyDeletehttp://www.mssqltips.com/sqlservertip/1529/how-to-build-a-cube-without-a-data-source-using-sql-server-analysis-services/
ReplyDelete