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  SQL Server 2000 Forums  Analysis Services (2000)  Problems importing data fro sql into analysis serv

Author  Topic  shudd Starting Member 5 Posts Posted - 2007-05-25 : 17:59:54 I have a sql database being updated each minute,analysis services automatically pulls this data into a cube.This works well when the sql has no indexes, with indexes the import and cube build only works once. I believe this is because the connection is always on? how would i drop the connection and then reconnect prior to the import. I hope that this will allow the cube to be build each minute starting with a fresh connection Thanks to anyone who can help