Hi All

I'm trying to build my first Analysis Services (2005) cube based on fact and
dimension tables on a SQL200 database on a different server.

I'm having problems setting up the data sources - I'm assuming I need two:
one for the source SQL2000 tables and one for the target SQL2005 cube. I've
done this but when it comes to deploying the cube it looks like it's
expecting the source tables on my SQL2005 data source

I think I'm missing something fundamental. Any help or suggestions most
welcome.

Thanks
Peter

Hi,

I only need a Datasource and that is to connect to the SS2000.

Be aware that there might be 2 different OLE DB for SS (the native 2005 and
previous one for 2000).

"P" wrote: