Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  analysis services connection to sql

Author  Topic  shudd Starting Member 5 Posts Posted - 2007-05-25 : 16:00:50 i have been working with a developer to build an application to collect real time data and then transfer the data over the internet importing it as a csv file into sql. each minute i rebuild an analysis services cube. This has worked well until the developer introduced an index. Now the cube will build only once and then fails.I have been told that one way to overcome this is to open and drop the database connection just befor i import the data in analysis services. any assistance greatly appriciated please note that i am not very technical Thanks