Microsoft® SQL Server® 2008 Reporting Services Step by Step

Configuring Data Source Properties

You will likely design and test reports in BI Dev Studio by using a local data source that contains a representative subset of production data. By limiting the data used for report development, you can avoid long waits for report execution. On the server, however, you want reports to retrieve data from the production data sources. You can maintain one data source for your development environment and another for your server environment. The OverwriteDataSources property for the project controls whether the data source in your project gets copied to the server. By default, deployment copies the data source file the first time, but subsequent deployments ignore the data source file, allowing you to change the properties ...