Wow... a blast from the past. Yeah got it working thanks :cool:. We used a system enviro var setup on each server and each dev workstation.

This pointed to the location for the configs. That way we could have configs specific to where the package was run or developed.

But... Now with 2012 that whole config setup is out the window anyway. Using project deployment model and the server Environments. But we did lose the functionality on the development side. Now the best thing seems to be for the developers to use server aliases (that are all the same) and build the project using those names so when we run locally (debug) it defaults to the param value since there is no server environment and they dont need to be messing with param values. Oh yeah we all run our own dev SQL instance. 😀