Hi All

Any help will be appreciated. We have a typical setup, a test server and a production server. I just set up the production server and archived the entire database that my cubes are in on the test server and restored them to the production server. This carried over the name of the data source from the test server and I just went in and changed the server name for the data source on the prod server (Should be pointing to the SQL 2000 database on the prod machine). Processed it OK. So far so good...

I now want to update a version of one of the cubes on the Prod server..... can't archive a single cube....I have them both in the same AS Manager so I right click on the cube on the test server and then click copy...... go to the prod. server and on the Data base name paste the cube. I get the following error......(paraphrase

"Cant copy the cube. The target database has a data source that has the same name as a data source in the source cube, but some of the connection string properties are different (....Yea, I know the server name is different!) Each data source used in a database must have a unique name within the database.

I really dont care what the name is, as long as the data source points to the correct place, right now the data source in Prod has a name that refers to the test server (When you create a data source, you do not have the option of naming it but you can rename it after the fact.) If I have a new data source for the prod server, I know where to change the data source for the partitions but not for the cube itself

I was able to copy the cube if the data sources match exactly

Is it as simple as changing the data source in Prod to match the data source in test, then copying, then changing the data source back and then processing the cube? Seems like it should work without doing this

Thank
Joh