what do you want to set the connection string with variable?
if yes, you can click on connection manager, then go to properties pane, and in the expression property set the ConnectionString with the variable.
but if you mean anything else, explain more...
http://www.rad.pasfu.com