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.
No comments:
Post a Comment