Brian,

Our development group currently uses this same method to dynamically assign connections as well. What I am curious about is that you stated it was better to assign the dynamic values to the database and server values rather than the connection string. Could you elaborate further? In our environment we have been assigning the dynamic value to the connection string and I am wondering if by doing that is that the source of the problems we seem to have when promoting SSIS packages to our production environment and the server names are different.