Multiple Environments and Configuration File settings in packages.

Suppose 2 environments on a single machine.

Each environment has different configuration settings....different

databases etc.

All the packages in the first environment have a hardcoded config files

referencing the local drive.

In order to create the second environment do I have to

go into each package and manually change the location of the

hardcoded config files. If I don't it will it not use the config files

from the first environment.

Thanks

What you can do is store the config file reference in a environment variable and change it between executions. You might have to use the command line mode for that.
Creat a batch file like this:

- pseudo code
Set env_variable = config1

dtexec.exe package.dtsx (not the correct syntax but to give you an idea)

Set env_variable = config2

dtexec.exe package.dtsx

-

Also, check ProjectREAL stuff. It'll give you a better idea.

Hope that helps.

Multiple configuration question

Hi,

I have an analysis project with 4 configurations

- Development

- Test

- Acceptance

- Production

In each configuration I have set correctly the deployement server.

But the datasources are also dependend of the configuration.

So how can I specify different datasources for each configuration ?

With regards,

Constantijn Enders

The ConnectionString of a DataSource is per configuration. To set it, use the DataSource dialog in each configuration.

These are all the properties that can be customized per configuration:

ReportServer of ReportAction objects Path of ReportAction objects StorageLocation of Cube objects ConnectionString of DataSource objects ManagedProvider of DataSource objects KeyErrorLogFile of ErrorConfiguration objects (used in Dimensions, Cubes, MeasureGroups, Partitions and MiningStructures) StorageLocation of MeasureGroup objects StorageLocation of Partition objects|||

Great, it works.

Thanks

CE