replace table with different datasource in dsv

HI all,

I've used test db which is the small portion of production db and now I'm trying to replace all tables with production db in dsv. But it gives an OLE DB error now. (but I checked it and nothing wrong with it.)

What should I check when replacing table with differenct db?

Do I check the data source references in ds?

Please give me some comments.

Thanks in advance.

If the table names and schema names (on which you built dimensions, cubes and partitions) are the same in the test and production databases, the only thing you need to change is the connection string of the DataSource object, to use production database as the default catalog.

Adrian Dumitrascu