Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
influent
Constraint Violating Yak Guru
367 Posts |
 Posted - 2008-09-17 : 14:49:08
|
| I created a dtsx package and a configuration file. The package has several variables with default values that I set in BIDS for testing. The variable values I want the package to use are set in the config file. When I run the package on the server, even though it's pointing to the configuration file properly, as far as I can tell, it's still using the default values. Why is that? It's a pain to wipe out all the default values in BIDS before I save the deployment version and then have to repopulate them when I need to change and test again. |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2008-09-18 : 16:34:19
|
| I finally got my XML configuration file working (i.e. being used by the package). Apparently the trick was to put ONLY the variable value nodes in the config file. BTW, the variables were used in expressions that made up connection strings, for anybody having the same problem. |
 |
|
|
|
|
|
stop default variable values from being used