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

Repeating subrecords n datasource

Hi all,
Can i place Different Reports having the "same" Subreports and Datasource
at the time of production.Means i don't want to deploy subreports n
datasources two times.
Is it possible?If so how can i ?
Ur suggestions will be appriciate
simmiYes. Use shared datasource, modify all RDL to reference the locations, and
deploy...
See help and rdl specifications for more details.
One approach to modifying the rdl and post it is to utilize .net framework
xsd.exe /c and the rdl xsd, deserialize, modify, serialize and createreport.
David Crawford [MSFT]
http://blogs.msdn.com/dc995
Disclaimer :
This posting is provided "AS IS" with no warranties and confers no rights.
"simmi" wrote:
> Hi all,
> Can i place Different Reports having the "same" Subreports and Datasource
> at the time of production.Means i don't want to deploy subreports n
> datasources two times.
> Is it possible?If so how can i ?
> Ur suggestions will be appriciate
> simmi