All I want to know is...
Is it possible to have an ODBC data source in Analysis Services 2005?
(I am using the June CTP of SQL 2005. I create a new Analysis Services Project using VS 2005. When I try to add a new data source, "ODBC" is not listed in the Provider list. What am I doing wrong?)
Reply from newsgroup from Microsoft:
AS2005 is not going to support ODBC data source. However, you can try to
create a data source in SSIS project. Then, add the data source into new AS
project. You should be able to create DSV, cube and dimension, etc.
However, since this feature is not supported. Believe that this area has not
been tested enough and this may break engine or not working probably. It is
"AS IS" if you really want to use it.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Ken Kwok
SQL Server Analysis Services
No comments:
Post a Comment